+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Mangesh Yadav
    Guest

    Setting round numbers for the scale

    Hi,

    My Y-axis scale works out to something like -1.1 to 4.5. The min could be
    anything (-1.5, 1.29, -0.98). What happens is that the units displayed are
    then started with the base value of the min, and the result is that in most
    of the cases, 0 is not one of the ticks. Is there a short-cut wherein we can
    ensure that 0 is always one of the ticks, and in the above case the ticks
    start from -1 instead of -1.1, and the range starts from -1.1.



    --
    - Mangesh
    ------------------------------------------
    Office 2003 & Windows XP



  2. #2
    Andy Pope
    Guest

    Re: Setting round numbers for the scale

    Hi,

    How about a work around. Add a dummy data series to the chart and change
    its chart type to xy-scatter. Depending on the main chart type set the x
    and y value to plot the point on the intersection of the x and y axis.
    Format the data marker to be a small cross. Add a data label to display
    the y value of zero. Align the data label to the left so it appears as
    part of the y axis.

    Cheers
    Andy

    Mangesh Yadav wrote:
    > Hi,
    >
    > My Y-axis scale works out to something like -1.1 to 4.5. The min could be
    > anything (-1.5, 1.29, -0.98). What happens is that the units displayed are
    > then started with the base value of the min, and the result is that in most
    > of the cases, 0 is not one of the ticks. Is there a short-cut wherein we can
    > ensure that 0 is always one of the ticks, and in the above case the ticks
    > start from -1 instead of -1.1, and the range starts from -1.1.
    >
    >
    >
    > --
    > - Mangesh
    > ------------------------------------------
    > Office 2003 & Windows XP
    >
    >


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

  3. #3
    Mangesh Yadav
    Guest

    Re: Setting round numbers for the scale

    Hi Andy,

    Thanks for the tip.

    Mangesh



    "Andy Pope" <andy@andypope.info> wrote in message
    news:#CXtVzXtFHA.2392@tk2msftngp13.phx.gbl...
    > Hi,
    >
    > How about a work around. Add a dummy data series to the chart and change
    > its chart type to xy-scatter. Depending on the main chart type set the x
    > and y value to plot the point on the intersection of the x and y axis.
    > Format the data marker to be a small cross. Add a data label to display
    > the y value of zero. Align the data label to the left so it appears as
    > part of the y axis.
    >
    > Cheers
    > Andy
    >
    > Mangesh Yadav wrote:
    > > Hi,
    > >
    > > My Y-axis scale works out to something like -1.1 to 4.5. The min could

    be
    > > anything (-1.5, 1.29, -0.98). What happens is that the units displayed

    are
    > > then started with the base value of the min, and the result is that in

    most
    > > of the cases, 0 is not one of the ticks. Is there a short-cut wherein we

    can
    > > ensure that 0 is always one of the ticks, and in the above case the

    ticks
    > > start from -1 instead of -1.1, and the range starts from -1.1.
    > >
    > >
    > >
    > > --
    > > - Mangesh
    > > ------------------------------------------
    > > Office 2003 & Windows XP
    > >
    > >

    >
    > --
    >
    > Andy Pope, Microsoft MVP - Excel
    > http://www.andypope.info




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