PivotGraph secondary y-axis

[yeti]

Help.

Am using a pivot-table to generate a pivot graph in excel 2000. I have three series plotted against time.

One of these series is much smaller than the others - and cannot really be seen if plotted using the same y-axis as the other two.

So, I've assigned this series to the 'secondary y-axis' and all is well and good - Until I refresh my pivot data...

It then reverts to the primary y-axis. Grrr

Is there a way of preventing this???

Any help would be appreciated.

Andrew

 

[SkipVought]

yeti,
1. Macro record the steps for assigning the secondary axis
2. clean up the recorded code
3. Make a commandbutton to refresh data and run your new routine
Skip,
Skip@theofficeexperts.com