Year One Expenses — Visualized
Experimenting with embedded Silk data visualizations
TLDR; If you make a Silk, then any visualization you generate using Silk can be embedded as an interactive…medium.com
I found the Silk manual entry option to be really clunky and counter-intuitive to use, so I dumped that data and instead pasted in a simple spreadsheet I made in OpenOffice Calc and this worked ten times better. I still think for ease of use and organizing data, I prefer Airtable — but I didn’t see any visualization options with them and their embeds don’t work on Medium (yet!).
Here is just a simple table view of my data after importing my pasted in spreadsheet (incidentally, the embed instructions provided by Silk above are wrong — here is a correction):
Outside of the simple table view, there are a number of other options, only a sampling of which I will include here.
Here is a somewhat cluttered pie chart showing all 18 expense areas:
I tried to render a second pie chart that groups the various areas into 7 different categories to give a somewhat clearer picture, but I found that the data that Silk put out for me to have inaccurate percentages.
Personally, I don’t have the time to pour into an application that doesn’t work the way I expect it or need it to, so encountering this kind of simple hiccup in adding up items by category is kind of a deal-breaker for me. I had to go and create a new collection by pasting in a new spreadsheet that I made in Calc, and then rendering that as a new pie chart. I think this more accurately breaks down the expenses by category or group:
Anyway, Silk certainly offers some interesting avenues to explore for data visualization, but I just haven’t found it personally reliable enough to continue using. I can, after all, just produce simple pie charts in OpenOffice Calc, anyway!