Setting round numbers for the scale

M

Mangesh Yadav

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

Andy Pope

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
 
M

Mangesh Yadav

Hi Andy,

Thanks for the tip.

Mangesh



Andy Pope said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top