Hi all,
I'm reposting this with more info and a better title.
I have a stacked chart with the largest number (19,000) formated so you can't see it (no fill, no line etc). It's intentional as I'm only using this to get the first series in the right place with the right values.
If I use numbers totalling 22800 or less I get outcome A where the axis number starts at 17000, if I use numbers totaling 22801 or more it looks like outcome B where the axis number starts at 0.
I have also tried 16.7999 gets chart B, 16.8 gets chart A.
So it sounds like the automatic bounding for the axis isn't doing very well.
I want outcome A "look" no matter the total.
Would it be possible to set the axis boundary using a formula or some other code? I've googled this but can't find anything other than altering the "Bounds, Minimum and Maximum", but this is hard set and my numbers in this chart change drastically.
The format Axis options only allow you to use numbers, I can't insert a formula here.
Another example but with lower numbers...from 16.7 (bottom of chart shows 12.5) to 16.8 (bottom of chart shows 0)
I'm reposting this with more info and a better title.
I have a stacked chart with the largest number (19,000) formated so you can't see it (no fill, no line etc). It's intentional as I'm only using this to get the first series in the right place with the right values.
If I use numbers totalling 22800 or less I get outcome A where the axis number starts at 17000, if I use numbers totaling 22801 or more it looks like outcome B where the axis number starts at 0.
I have also tried 16.7999 gets chart B, 16.8 gets chart A.
So it sounds like the automatic bounding for the axis isn't doing very well.
I want outcome A "look" no matter the total.
Would it be possible to set the axis boundary using a formula or some other code? I've googled this but can't find anything other than altering the "Bounds, Minimum and Maximum", but this is hard set and my numbers in this chart change drastically.
The format Axis options only allow you to use numbers, I can't insert a formula here.
Another example but with lower numbers...from 16.7 (bottom of chart shows 12.5) to 16.8 (bottom of chart shows 0)