| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Y Axis To Time Increments
I want to set Major unit for the Y Axis to even time intervals, such as 2:00
minutes. In Excel 97-2000, you would just put in "2:00" and it would convert it to a number and the intervals would be even number. Excell 2007 does not allow me to do that in the Axis Options. Can someone help? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Formatting Y Axis To Time Increments
Nobody can help. Microsoft forgot to build this capability into the new
chart formatting dialogs in Excel 2007. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ron" wrote in message ... I want to set Major unit for the Y Axis to even time intervals, such as 2:00 minutes. In Excel 97-2000, you would just put in "2:00" and it would convert it to a number and the intervals would be even number. Excell 2007 does not allow me to do that in the Axis Options. Can someone help? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Formatting Y Axis To Time Increments
It does work in Excel 97-2000. All you have to do is type "2:00" or 2:00:00"
in the number box next tot he Major Unit selection. when you tab out, it will convert it to a decimal number. Excel 2007 does not do this, now. When you tab out it goes back to the value that was in the field, originally. "Jon Peltier" wrote: Nobody can help. Microsoft forgot to build this capability into the new chart formatting dialogs in Excel 2007. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ron" wrote in message ... I want to set Major unit for the Y Axis to even time intervals, such as 2:00 minutes. In Excel 97-2000, you would just put in "2:00" and it would convert it to a number and the intervals would be even number. Excell 2007 does not allow me to do that in the Axis Options. Can someone help? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Formatting Y Axis To Time Increments
It works in 97 through 2003, and probably earlier. But the people designing
the interface only thought of dates in the date-scale category axis, completely forgetting how useful it is to have the ability to enter dates or times or ANY number format in a dialog. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ron" wrote in message ... It does work in Excel 97-2000. All you have to do is type "2:00" or 2:00:00" in the number box next tot he Major Unit selection. when you tab out, it will convert it to a decimal number. Excel 2007 does not do this, now. When you tab out it goes back to the value that was in the field, originally. "Jon Peltier" wrote: Nobody can help. Microsoft forgot to build this capability into the new chart formatting dialogs in Excel 2007. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ron" wrote in message ... I want to set Major unit for the Y Axis to even time intervals, such as 2:00 minutes. In Excel 97-2000, you would just put in "2:00" and it would convert it to a number and the intervals would be even number. Excell 2007 does not allow me to do that in the Axis Options. Can someone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get the category axis units to be in even increments? | Charts and Charting in Excel | |||
| How do I set my X axis to include equal increments of a day? | Charts and Charting in Excel | |||
| Time increments | New Users to Excel | |||
| Excel has created Y-axis increments of .14! | Charts and Charting in Excel | |||
| formula for defining axis maximum and increments | Charts and Charting in Excel | |||
Hybrid Mode
