Axis Options - Bounds - Change with Pivot Table values

[RodneyW]

I have a pivot table set up, with a Slicer all feeding to a chart. My challenge is there are about 100 different options for the Slicer. Some of them have very high numbers relative to others. I currently have the Axis Options set as shown below. For several of the Slicer selections, this works perfectly. For others, the 2.5M ceiling is very high and the bars representing the data barely are above the very bottom of the chart. If I change the 2.5M ceiling so these low number selections (which are performing well, despite the relatively low numbers), the selections with higher numbers blow off the top of the chart. So, here's my question... Can the Axis Option be set so when the numbers are high, it will max out at 2.5M and when low, max out at 500,000. Those numbers are purely for example. Actual numbers may need to be different. Thanks in advance

 

[RodneyW]

Replying to my own post to push it back to the top

 

[RodneyW]

Bump