I often plot measured data as a scatter plot with the value on the Y-axis,
and a time or date on the X-axis.
The wizard will pick default values for the X-axis that usually need to be
altered.
Since moving to Excel 2007 I have been unable to specify the X-axis min and
max values as dates or times. With '2003 I used to be able to specify, say,
a minimum of 08/09/2008 09:00 and a maximum of 08/09/2008 09:10. Now I would
have to use numeric values of 39699.375 and 39699.3819444.
Does anyone know a way of doing this?
Thanks

Hi,

That convenient auto conversion does not occur in 2007.
You will need to use a cell in each to enter the date and the format as
number in order to see the real date value.

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SJAndre" wrote in message
...
I often plot measured data as a scatter plot with the value on the Y-axis,
and a time or date on the X-axis.
The wizard will pick default values for the X-axis that usually need to be
altered.
Since moving to Excel 2007 I have been unable to specify the X-axis min
and
max values as dates or times. With '2003 I used to be able to specify,
say,
a minimum of 08/09/2008 09:00 and a maximum of 08/09/2008 09:10. Now I
would
have to use numeric values of 39699.375 and 39699.3819444.
Does anyone know a way of doing this?
Thanks

Thanks for this, Andy. Not the answer I'd hoped for, but the one I expected!
Perhaps a suggestion for a future update?

"Andy Pope" wrote:

Hi,

That convenient auto conversion does not occur in 2007.
You will need to use a cell in each to enter the date and the format as
number in order to see the real date value.

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SJAndre" wrote in message
...
I often plot measured data as a scatter plot with the value on the Y-axis,
and a time or date on the X-axis.
The wizard will pick default values for the X-axis that usually need to be
altered.
Since moving to Excel 2007 I have been unable to specify the X-axis min
and
max values as dates or times. With '2003 I used to be able to specify,
say,
a minimum of 08/09/2008 09:00 and a maximum of 08/09/2008 09:10. Now I
would
have to use numeric values of 39699.375 and 39699.3819444.
Does anyone know a way of doing this?
Thanks

It's been suggested. I hope it's on the short list of improvements.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"SJAndre" wrote in message
...
Thanks for this, Andy. Not the answer I'd hoped for, but the one I
expected!
Perhaps a suggestion for a future update?

"Andy Pope" wrote:

Hi,

That convenient auto conversion does not occur in 2007.
You will need to use a cell in each to enter the date and the format as
number in order to see the real date value.

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SJAndre" wrote in message
...
I often plot measured data as a scatter plot with the value on the
Y-axis,
and a time or date on the X-axis.
The wizard will pick default values for the X-axis that usually need to
be
altered.
Since moving to Excel 2007 I have been unable to specify the X-axis min
and
max values as dates or times. With '2003 I used to be able to specify,
say,
a minimum of 08/09/2008 09:00 and a maximum of 08/09/2008 09:10. Now I
would
have to use numeric values of 39699.375 and 39699.3819444.
Does anyone know a way of doing this?
Thanks