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.

[gdoc key=”18bz_yORMqagch12108y5flvJmxr776oQirb1vlxq0io” title=”Blood Glucose levels – mmol/L – April to June 2018″  chart=”Area” chart_legend=”Right” chart_height=”400″ chart_animation=”true” chart_point_size=”6″ chart_colors=”FDBB0E” chart_color_axis=”#FDBB0E”][gdoc key=”1Qu3QULdavSmPjDwyec4hnwvpypeYJMaNtuDEsQB_udg” chart=”Pie” title=”Grams consumed by nutrition type” chart_pie_hole=”0.5″ chart_height=”600″ chart_colors=”#AB86B7 #CD8CF2 #FBD980 #A1D8D4 #FB9180″]

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.


Pin It on Pinterest

Share This