Thread: Y Axis values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Y Axis values

To get two axes you need at least two data series. Why not use the same data
twice? Select the y-values, copy and drag to the chart. Now format the
second data series to use the secondary y-axis. You will nee to format the
line/markers so that the chart displays just one data series.
There are more elegant ways but this is quick!
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"glenlee" wrote in message
...
How do I get the Y axis values for a line chart to appear on both the
left and right sides of the chart?