Automate Min Max Y Axis on Excel - Excel for Finance Analysts, Accountants & Auditors [part 8]

[@mattharris8324]

Paul - I have been looking for this fix forever. Thank you!

[@KennethDerr]

Much simpler than the VBA I was using. I am so grateful!

[@nirav2811]

Thank you brother!!! you make my work easy...

[@DreamFirms]

Hey Paul, thanks for this tip!

[@rodrigopinot3599]

Great Stuff in deed, complex topic, explained brilliantly, thank you!

[@hsinhsinpink]

very useful! learnt a new tip today

[@shervanyousefi3755]

Thanks that was very helpfull. How can I do the same thing for the Secondary Y-Axis as well? (on the same Chart)

[@TomHolmHansen]

Hi Paul, This is exactly what I have been looking for - except I need it for Google sheets where I am creating charts based on the "googlefinance" function! Would you have any suggestions how this can be implemented in their macro tool?

[@connerprestonpierce]

How do you do this also for the X axis?

[@AdamThomson-tk2jw]

Paul can you do this without VBA or macros. I do not have access to developer

[@janekasiman549]

Can you do this with multiple charts in a same sheet? It is not working for me so far. Thanks

[@johanlahti357]

Hey Paul! Great stuff! Any videos for controlling the X axis also?

[@aleksanderskiba3759]

Hi, I found in some text tutorial that it is explaning you can choose the axis by changing ValueOrCategory. “Value” is Y and “Category” is X (it will also accept “X” or “Y”)

[@jamesrice5683]

where's the code please?

[@RomaStreetDentalBrisbane]

In the grey box above click on the word "more" at the very end. The grey box will expand and the VB code and the other forumlas referred to in the video are displayed. Don't thank me... found it by accident! 🙄

[@markmelbourne6041]

No code. Bummers