View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Adding a secondary axis to an exisitng chart

Right click on one of the data series in the chart and from the shortcut
menu use Format Series;
Open the Axis tab and click on the Secondary Axis option
If the chart is column you will need some extra steps; see
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Randy" wrote in message
...
When working through the Excel Help explanation, I can't find the "Series
Options" Where is it?