Remember Me?

#1
 Dave R. Posts: n/a
space between y axis and data points..

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.

#2
 Barb Reinhardt Posts: n/a

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
he

http://www.peltiertech.com/Excel/Cha...ml#VertCatAxis

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

"Dave R." wrote in message
...
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.

#3
 Dave R. Posts: n/a

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

#4
 Jon Peltier Posts: n/a

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

Dave R. wrote:

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post ramseysgirl Charts and Charting in Excel 8 December 29th 04 06:00 PM Phil Hageman Charts and Charting in Excel 4 December 29th 04 11:51 AM David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM Peter Carr Charts and Charting in Excel 1 December 15th 04 09:11 AM NTE Charts and Charting in Excel 10 December 13th 04 06:34 PM

All times are GMT +1. The time now is 09:50 PM.