Right-click on the series you want to change, and select 'Format Data
Series'
On the Axis tab, select Secondary Axis, click.
However, loss of formatting is a known problem with pivot charts, so you
may want to record a macro as you change the axis. There's information
in the following MSKB article:
Changing a PivotChart Removes Series Formatting in Excel
http://support.microsoft.com/?id=215904
controlsrfun wrote:
Is it possible to have a pivotchart with a primary & secondary axes in Excel
2002? If so, how do you setup the secondary axes?
Thanks
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html