ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Secondary axis in PivotChart? (https://www.excelbanter.com/charts-charting-excel/119732-secondary-axis-pivotchart.html)

[email protected]

Secondary axis in PivotChart?
 
I am trying to add a secondary axis to my PivotChart (in the same
manner as a normal Chart) and find the option is greyed out:

I select the data series,
Go to Format Selected Data Series Axis tab
The "Plot Series on" radio button selector is greyed out.

Is there a way to activate this option for PivotCharts? Or some other
way to achieve a similar result?

I just want two Y axes on either side of the report with different
scales to appear.



All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com