do you mean a macro to loop through the charts and set the Min, Max and
Increment values?

Turn on the macro recorder and do it manually - then turn off the macro
recorder and look at the recorded code. Then adjust/genralize that code to
achieve your objective including adding a loop to loop through the charts.

--
Regards,
Tom Ogilvy


" wrote:

Hi all

I'm using a chart with two Y axes - eg the Left axis (LA) could be MW
of Generation and the Right axes (RA) could be total electric demand.
What I want to do is find a way to adjust the RA - so that it exactly
matches the scaling on the LA . Right now, I have the LA scaled as
follows :

min 0
max 70000
increment 10,000

RA
min 15000
max 60000
step 5000

I have about 10 such charts, which update everyday. Is there anyway
(excel formula or VBA code) to get the RA to "mirror" the LA?

thanks
chet