Charting with a secondary Y Axis

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

How do I create a line graph with two Y axis? I want to
compare two sets of data, but the ranges are drastically
different. Any help is appreciated, thanks
 
Hi Matt,
Make chart in normal way
Right click one of the data series in the chart; select Format Data Series
from popup menu
Open Axis tab, click next to Secondary Axis.

Best wishes
Bernard
 
You must log in or register to reply here.

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: 2 Lines on secondary Y-axis? 1
Coordinate secondary y axis to primary y axis 2
Chart distorts secondary axis when the x-axis is logarithmic 5
Make Y-axis values correspond to x- axis value 1
How can I make a scatter plot graph with a category x-axis? 0
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Using the full width of an Excel chart with two Y-axes 2
Chart - Secondary Y-axis with different values/scale 2

Back
Top