+ Reply to Thread
Results 1 to 5 of 5

space between y axis and data points..

  1. #1
    Dave R.
    Guest

    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. #2
    Barb Reinhardt
    Guest

    Re: space between y axis and data points..

    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/Cha...ml#VertCatAxis

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


    "Dave R." <[email protected]> wrote in message
    news:%[email protected]...
    > 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. #3
    Dave R.
    Guest

    Re: space between y axis and data points..

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



  4. #4
    Jon Peltier
    Guest

    Re: space between y axis and data points..

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



  5. #5
    Registered User
    Join Date
    02-10-2005
    Posts
    2
    This works great, except that now there are too many tick marks. Any way to fix that?

    thanks,

    Fred Aswad

    Quote Originally Posted by 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/
    _______

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1