how to add a secondary axis in excel chart?

A

Andy Pope

Hi,

You need a chart with 2 series. Double click the series and on the axis tab
select Secondary axis.
Not available for any 3d chart styles.

Cheers
Andy
 
D

David Biddulph

You'll need to have at least 2 data series in your chart.
Select a series, format axis, and at that stage the secondary option should
be available. Initially it will give you a secondary Y-axis, but
subsequently you can change to have a secondary X-axis instead of, or as
well as, the secondary Y-axis.
 

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

Finding asymptote equation and how to draw them in excel 0
Primary X axis to Secondary X axis 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Scatter chart with categories on x-Axis 2
Coordinate secondary y axis to primary y axis 2
Secondary axis not aligning to X axis 1
Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
simple chart 0

Top