Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 axis format
In earlier versions of Excel you were able to just type in dates for the
x-range in a xy-graph (i.e. 01/15/07). In my case I have to use a xy-graph because I am having timeseries with timevalues. Because of that the line-chart is not sufficient to fulfill my needs. Today (in Excel 2007) you have to know the number of days since jan 01 - 1900 (i.e. 39095) !! Is there a way to do it "the good old way" in Excel 2007 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 axis format
They broke this capability. I've already submitted it as a bug.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jesperfect" wrote in message ... In earlier versions of Excel you were able to just type in dates for the x-range in a xy-graph (i.e. 01/15/07). In my case I have to use a xy-graph because I am having timeseries with timevalues. Because of that the line-chart is not sufficient to fulfill my needs. Today (in Excel 2007) you have to know the number of days since jan 01 - 1900 (i.e. 39095) !! Is there a way to do it "the good old way" in Excel 2007 ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 axis format
Thank's for your answer and your action.
I hope they will fix it :-) "Jon Peltier" skrev: They broke this capability. I've already submitted it as a bug. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jesperfect" wrote in message ... In earlier versions of Excel you were able to just type in dates for the x-range in a xy-graph (i.e. 01/15/07). In my case I have to use a xy-graph because I am having timeseries with timevalues. Because of that the line-chart is not sufficient to fulfill my needs. Today (in Excel 2007) you have to know the number of days since jan 01 - 1900 (i.e. 39095) !! Is there a way to do it "the good old way" in Excel 2007 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why can I not format a secondary axis in excel x? | Charts and Charting in Excel | |||
Dates in Excel 2007 graph axis dialogs | Charts and Charting in Excel | |||
Convert Excel 2007 format (*.xlsx) into Excel 2003 format | Excel Discussion (Misc queries) | |||
2 axis in excel 2007 | Charts and Charting in Excel | |||
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit | Charts and Charting in Excel |