How to properly normalize sparkline column chart in Google Sheets

Johnny Derpp 0
Viewed 39

See image below for reference.

enter image description here

When I simply create a column chart of the items in column A, I get what seems like improperly scaled columns? 5 looks like just a line where 10 would seem to fully occupy the vertical height. I believe this would count as a Normalization problem? Correct me if I'm wrong. Anyhow, the solution seemed to be the ADDING of Zero as you'll see in D3. This has its own problem, though: The addition of an additional column - what would have been 4 columns is now 5 (the first one being invisible since it is just 0).

TL;DR: How can I use sparklines wherein I don't have to add additional zero AND STILL retain the normal scaling of columns as in the case of regular column charts (i.e. non-sparkline)?

I could share the link to the sample sheet, if you need them. Thank you.

sparklines google-sheets
2 Answers

The problem is not one of normalizing the data; it's a problem with the graph axis not starting at 0. To give the bars properly scaled heights, force the y-axis to start at 0:

=SPARKLINE(A2:A5,{"charttype", "column"; "ymin", 0})
Aaron Dunigan AtLee0

Found a fix. I got the idea from here: Math: I need to normalize some bar graphs I had to use the weighted average from the mentioned link in addition to using the "ymin" argument for the column. Curious, though, how I still had to set such ymin to the original minimum number (5) from the original list in Column A, instead of the one from 'adjusted values' in Column B, which would be 7.5. enter image description here I guess this works for me, though I hate that there is a need (?) to save the adjusted values first before I can perform the sparkline formula. Think I'll just ask that separately so considering this one case closed unless there are better solutions that come up.

=SPARKLINE(B2:B5,{"charttype", "column"; "ymin", min(A:A)})
Johnny Derpp0
Related