Excel: line charts, how to "scale" data...

[andylawcc]

okay, let's say i have three lines,

line #1 is 1, 2, 3, 4, 5,
line #2 is 1.1, 2.2, 3.3, 4.4, 5.5
line #3 is 10, 20, 30 ,40 ,50

the third line will be graphed way above line 1 and 2, is there a way to put them closer? or "crop" the empty space between line 1/2 and 3?

 

[Binky]

Right click the offending line on the chart
Select the bottom option - format data series
Click the first option - secondary axis

Now you can adjust each axis scale independently to make them fit how you want them to fit.

These instructions are based on the menus for excel 2010.

 

[andylawcc]

omg, thank you!!!