Hi,
I am hoping that someone will be able to help me. I have no Visual Basic knowledge and am utilising the kindness and generosity of others to help solve my problems.
Using a previous thread http://windowssecrets.com/forums/showthread//23749-Macro-to-adjust-scale-of-Chart-Axis-(Encligh-Excel-XP) I have been able to create a Macro that set the primary y-axis values that I need for my chart. However, need to take this a step further.
I have four charts within my spreadsheet and need the values to be applied to three of these four charts. Can this be done?
In addition, I also need to be able to set the secondary y-axis values.
Thank you in advance for any help/advice/guidance that you can offer.
Robin