Chart size

[JKC]

I have a simple line graph on a worksheet. How can I eliminate large gap
between end of graph and edge of chart. I looked in all properties etc.
but I can't figure out how to make end of graph line go the edge of the
graph area. Thanks

 

[Andy Pope]

Hi,

If you want the line to go from edge to edge of the plot area then
double click the x axis and on the scale tab uncheck 'Y (value) axis
crosses between categories'

Cheers
Andy