dates on scatter chart axis

J

Jake

In setting the scale (Minimum and Maximum under Axis Options) a scatter data
graph axis, in Excel 2003 you could enter the date (e.g., 1/1/1987) . In
Excel 2007 it appears I can only enter the number (e.g., 31778) which is
quite difficult.

Is there a way in Excel 2007 to enter the date?
 
D

David Biddulph

No. Jon Peltier has pointed that out as one of a number of retrograde
changes in Excel 2007. As he has pointed out, the easiest option is to use
a worksheet to put the date you require into a cell and allow the sheet to
do the conversion to 31178, so that you can see which number to type (or
copy) into the Axis dialogue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extending The Horiz. Axis Question ? 1
How do I adjust marker spacing in Excel scatter plot? 1
Trying to change x-axis date range 5
scatter chart won't accept primary axis 4
Scatter Plot graph 1
Scale on X & Y Axis of the scatter chart 3
xy scatter with date/time as x axis 2
Defining X-axis scales as dates or times 3

Top