how differentiate between 3 closely spaced lines in excel graph
 

How do i change the excel chart features such that the 3 series /lines i have
are spaced further apart when displayed in a line graph. I think it must be
something to do with scales but tried variations to no effect.
Thanks
Mike

Hi,

Changing the y axis Minimum and maximum scale values may help. But not
if the actual values are very similar and span a large range.

Double click the y axis and on the scale tab enter alternative min/max
values.

Cheers
Andy

CookeMJ wrote:
How do i change the excel chart features such that the 3 series /lines i have
are spaced further apart when displayed in a line graph. I think it must be
something to do with scales but tried variations to no effect.
Thanks
Mike

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks Andy - your right actual values are very similar and the range goes
from 0 to 8. I've changed min and max values and not a lot of difference.
Thanks for the response
regards
Mike

"Andy Pope" wrote:

Hi,

Changing the y axis Minimum and maximum scale values may help. But not
if the actual values are very similar and span a large range.

Double click the y axis and on the scale tab enter alternative min/max
values.

Cheers
Andy

CookeMJ wrote:
How do i change the excel chart features such that the 3 series /lines i have
are spaced further apart when displayed in a line graph. I think it must be
something to do with scales but tried variations to no effect.
Thanks
Mike

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

one of the thhings you might do to show the difference is to pick one as a
basis, then show deltas to the other two. You can plot these three curves on
the same chart and just plot the basis on a different axis.

"CookeMJ" wrote:

Thanks Andy - your right actual values are very similar and the range goes
from 0 to 8. I've changed min and max values and not a lot of difference.
Thanks for the response
regards
Mike

"Andy Pope" wrote:

Hi,

Changing the y axis Minimum and maximum scale values may help. But not
if the actual values are very similar and span a large range.

Double click the y axis and on the scale tab enter alternative min/max
values.

Cheers
Andy

CookeMJ wrote:
How do i change the excel chart features such that the 3 series /lines i have
are spaced further apart when displayed in a line graph. I think it must be
something to do with scales but tried variations to no effect.
Thanks
Mike

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info