How to change chart y-axis scale on condition?

[cswshaun]

Hi all

I have 2 column pivot charts.

I am trying to achieve this:
When CELL AB1 is (ALL), I would like the maximum scale of y-axis of both chart1 and chart2 to be 600 and when CELL AB1 is any other value, the maximum scale should be switched to AUTO.

Is there a way to achieve this ?

thanks!

 

[GraH]

Cross-posted: https://chandoo.org/forum/threads/how-to-change-chart-yaxis-scale-on-condition.44390/#post-264817.

 

[Fluff]

@cswshaun
Also posted here how to align the y axis max scale of all charts in the worksheet - OzGrid Free Excel/VBA Help Forum

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Fluff]

Also posted Change chart y-axis scale on condition

If you have posted this on any other sites, please provide the link(s)

 

[Kaper]

And to complete the information about crossposting - I've answered this question 05-30-2020, 08:55 AM on Change chart y-axis scale on condition