Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Round whole numbers up and down | Excel Discussion (Misc queries) | |||
Can you format a whole column of numbers to round? | Excel Worksheet Functions | |||
Does Excel round numbers with a 5 in the tens place? | Excel Discussion (Misc queries) | |||
How to Round Whole Numbers? | Excel Discussion (Misc queries) | |||
Can you round numbers to display a specific set of numbers, for e. | Excel Discussion (Misc queries) |