Stacking Chart - Axis Bounds - can it be set using a formula or code?

dhodgson7

New Member
Joined
Apr 11, 2022
Messages
4
Office Version
  1. 365
Platform
  1. Windows
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.

1649728398247.png


1649670476241.png



1649670416401.png


Another example but with lower numbers...from 16.7 (bottom of chart shows 12.5) to 16.8 (bottom of chart shows 0)

1649728019599.png


1649728059662.png
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,223,907
Messages
6,175,301
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top