Setting round numbers for the scale

#1 09-09-2005, 04:05 AM

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 09-09-2005, 06:05 PM

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 09-10-2005, 02:05 AM

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 Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)