More Data

Oh I do love fiddling with data.  I’m not an academic, but I find a certain level of satisfaction in problem solving. After my previous post I was feeling peeved that to get what I really wanted (total control over the data) I would have to buy a premium plugin.

No longer!

The charts below are generated using a lightweight (and free!) plugin, Inline Google Spreadsheet Viewer.  Everything is controlled in one shortcode, edited manually using  a slew of attributes available from the Google API. And the best part? All the data is being pulled on the fly from the spreadsheets on Google Docs, so if I want to edit them I just go into the spreadsheet in question and change the values. Job done.

EDIT

I’ve removed the charts as I’m using a new plugin. You’ll just have to imagine they’re there! 

The food pie chart is a little misleading as it reads as if I’ve been stuffing carbs all day. The actual carb content overall came to 182g which is clearly not a days worth of food. I’m not sure how to best represent this, as there isn’t a ‘total grams consumed’ option in MyFitness Pal, and their exports require a premium subscription. No thanks. Also there are no calories in there, as they aren’t the same unit of measurement, so have to be mutually exclusive.

In truth, I would rather have used Chart.js as it’s charts are absolutely gorgeous. But this gives me the tools I want, with the added bonus of on-the-fly editing and data fed from a dynamic, external source. And no forking out for a one-off or recurring fee.

Leave a comment

The Illustators Agency logo
Sarah on Mastodon