View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Excel chart, right scale

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