Double Axix Charting off a pivot table

[george]

I have a chart pointing to a pivot table as its source.
Is there any way for me to add a secondary axis with the
pivot table being the source data?

Thanks!
George

 

[Debra Dalgleish]

1. Right-click on the series that you want to plot on the
secondary axis.
2. Choose 'Format Data Series'
3. On the Axis tab, select 'Secondary Axis'
4. Click OK

Note: If you refresh the chart, the formatting will be lost.
You can record a macro as you apply the formatting, then run the macro
after a refresh, to reapply the formatting.