Defining X-axis scales as dates or times

  • Thread starter Thread starter SJAndre
  • Start date Start date
S

SJAndre

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
 
Thanks for this, Andy. Not the answer I'd hoped for, but the one I expected!
Perhaps a suggestion for a future update?
 
Back
Top