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 ?

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 ?

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 ?