Double Axix Charting off a pivot table

  • Thread starter Thread starter george
  • Start date Start date
G

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
 
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.
 
Back
Top