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