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.
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.