Charting question

G

Guest

Is it possible to have two alternative scales on the same chart? If so How do
you set up the scale?

Thanks in advance for your help.
 
G

Guest

DaBears70,
Excel's help on this subject is close, not ideal.
If put numbers in cells D1:D6,E1:E6,F1:F6, and G1:G6.
Selected scatter plot, named the series what i wanted to, selected G1:G6 as
my x-axis, for each series (D1:D6,E1:E6,F1:F6) finished the chart as an
insert.
Selected the third series(F1:F6),right click,format data series, Axis
tab,select "Secondary axis".
HTH
:)
 

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

Charting a tertiary scale 1
Excel 2003 Chart use 5
Variable or Split vertical axis scales 3
Two alternative scales on same chart?? 1
Vertical line in a histogram (vertical bar chart) 0
Excel Charts 1
How to insert 2 scales on y-axis? 3
The scale on vertical axis equals to scale on vertical axis of ano 1

Top