space between y axis and data points..

[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.

 

[Barb Reinhardt]

I've had to kludge this by using a dummy (continuous) series for X (say 1
for PRE and 2 for POST) and plotting that data. I've set the X axis scale
as needed to get what I want and then used a procedure similar to that used
here:

http://www.peltiertech.com/Excel/Charts/DummySeries.html#VertCatAxis

to re-label the X-axis with the Character Info.

 

[Dave R.]

Good thinking Barb, I'll give that a shot.

 

[Jon Peltier]

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/
_______