space between y axis and data points..

  • Thread starter Thread starter Dave R.
  • Start date Start date
D

Dave R.

I have a line graph with markers, and am plotting 7 pre-post (x axis) lines
on a y axis of 1 to 100.

By default, the "pre" points were plotted right on the y axis and the post
points were all the way at the right end of the plot area. I checked "Value
(y) axis crosses between categories", and this moves the pre (and post)
towards the middle of the plot area, so that the points are now plotted to
the right of the y axis.

My question is, can I adjust the space between the y axis and where the
"pre" data points are plotted? As they are now, there is too much of a gap
between the y axis and the "pre" data points.

Thanks.
 
Dave -

An alternative is to insert a row/column between the before and after data, so you
have three categories, and the before and after points are farther apart. The blanks
mean there's no label for this category, and if you use the (Tools menu - Options -
Chart tab) Interpolate option for Plot Blank Cells, the line will still connect the
endpoints.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top