• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

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

A

andylawcc

Lifer
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?
 
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top