Charting with a secondary Y Axis

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
 
B

Bernard Liengme

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
 

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

simple chart 0
Make Y-axis values correspond to x- axis value 1
Graphs: 2 Lines on secondary Y-axis? 1
Use text descriptors as Y axis units 1
Finding asymptote equation and how to draw them in excel 0
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Comparative Scatterplot?? 1
Coordinate secondary y axis to primary y axis 2

Top