How do I add a secondary axis to a pivot table chart?

D

dangelor

Using XL2007 - the secondary axis radio buttons are greyed out. Is there a
way to add the 2nd axis?
 
S

Shane Devenshire

Hi,

This is chart type dependent. Suppose you have a line chart, right click
the series and choose Format Series, the Axis radio button should be
available.

What type of chart are you using?

Cheers,
Shane Devenshire
 

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

column charts with set set of data 0
Primary X axis to Secondary X axis 1
SECONDARY AXIS/series next to column 0
Chart distorts secondary axis when the x-axis is logarithmic 5
Charting on Primary & Secondary Axis - Zero Point Does Not Align 1
extra info is showing up in my secondary x axis, I can't get rid o 1
Chart data scrunches to left when adding X axis date series 0
Secondary Axis 1

Top