Knowledge Base Article
I've been using this script to great effect, but I just realized that it doesn't seem to be working the way I imagined. I had assumed the script was dynamically adjusting the "max" end of the scale so the labels naturally had enough room to display. Now that I'm looking at this again, though, it looks like I was wrong. You quite clearly said it "manipulates the columns' height and label position". I didn't realize until just now when I noticed that, in the "after" screenshot, the scale is exactly the same (max of 200).
This script is fine if you're going to be hiding the scale, but if you want or need to show the scale for some reason, then this might not be ideal because now the lengths of the bars don't match the scale. For example, the "199" bars show far lower than they should compared to where "200" is on the scale. Same with "160" (it's well below the half-way point between 100 and 200).
Is it possible to create a script that does what I was originally imagining? That is, dynamically adjusting the max scale? Using the built-in "auto" option is what leads to the covered-up values, so I just need a way to add an offset or buffer to that. (In the past I would just manually set the scale, but this isn't ideal since it doesn't update in response to different data.)