Y Axis values

  • Thread starter Thread starter glenlee
  • Start date Start date
G

glenlee

How do I get the Y axis values for a line chart to appear on both the
left and right sides of the chart?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

graphs 1
2nd Y Axis 3
Excel Chart question using two y axes 2
Horizontal axis to the bottom 1
How do I move the x-axis to the top of the graph? 1
2-y axis line chart 4
charting variable line data 1
Excel chart does not start at zero. 1

Back
Top