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
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
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks