|
|
|
||||||||||||
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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 |
![]() |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|