Hi,
I'm new to VBA but thanks to other experts, I was able to find a macro that lets me produce multiple charts from the same worksheet. However, I need to fix the minimum and maximum values for the y-axis for all of the graphs created using this macro. I can only find how to assign values to a specific chart. I want it done to ALL of them at the same time. Could someone add to this macro below? I need the minimum value to be 0.50 and the max to be 0.75. I also want the major interval to be .05 (and .02 for minor).
In the "sample" I attached, you will see that Excel automatically changed scaling. It's so misleading.
Thanks in advance.
Macro:
Bookmarks