Secondary axis in PivotChart?

R

roseyyy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Overlaying 2 Data Series with Different Time (X) Axis 3
Chart distorts secondary axis when the x-axis is logarithmic 5
Adding a secondary Axis to a graph 2
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Secondary Axis Data Series "Clumping" 3
Secondary Axis 9
X-Axis Appearing in Plot Area 2
Chart - Secondary Y-axis with different values/scale 2

Top