Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave R.
 
Posts: n/a
Default 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   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

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   Report Post  
Dave R.
 
Posts: n/a
Default

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


  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 06:00 PM
Secondary Axis Without Data Points? Phil Hageman Charts and Charting in Excel 4 December 29th 04 11:51 AM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM
Problem with date base units for x axis Peter Carr Charts and Charting in Excel 1 December 15th 04 09:11 AM
Y axis, need varying units 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.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"