ExcelBanter - How do I add two vertical scales to a line graph?

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - How do I add two vertical scales to a line graph? (https://www.excelbanter.com/charts-charting-excel/146090-how-do-i-add-two-vertical-scales-line-graph.html)

IronRobbie

How do I add two vertical scales to a line graph?

I'd like to create a line graph with two vertical scales, because my two sets
of data range from 10-20 and 1000-2000. Help is appreciated.

Bernard Liengme

How do I add two vertical scales to a line graph?

Right click one of the data series in the chart; format it; on Axis tab
specify Secondary Axis
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"IronRobbie" wrote in message
...
I'd like to create a line graph with two vertical scales, because my two
sets
of data range from 10-20 and 1000-2000. Help is appreciated.

All times are GMT +1. The time now is 10:57 AM.