1. Select the series that you want on the secondary axis
2. Choose FormatSelected Data Series
3. On the Axis tab, select Secondary Axis.
4. Click OK
To make it easier to interpret, you can colour the font of the axis
labels, to match the series colour. Jon Peltier uses this technique in
some of his examples:
http://www.geocities.com/jonpeltier/....html#Col2Axes
Richard wrote:
Is there a way to assign one of 2 data series to the right
scale in Excel chart, and keep the other data series in
the left scale? I don't see any reference to right scale
in the "Excel Help".
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html