Only if the data are in integral dates. All times for a given date are
plotted at midnight at the start of the day (i.e., the integer part of the
date-time).

Removal of the ability to enter dates and times into the scale parameter
boxes for a value axis has been a sore loss.

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


"Bernard Liengme" wrote in message
...
May I refer you to
http://peltiertech.com/Excel/ChartsH...ValueAxis.html
quote:
Line Chart: X as Time-Scale Axis
There is one exception to a Line Chart having evenly spaced categories.
This is the case of dates as X axis values. Excel calls this a Time-Scale
axis, but it is more accurately called a Date-Scale axis.

Time series ARE appropriately charted on LINE charts
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JRS" wrote in message
...

Line charts are only valid for categorical (non-numerical) data on the
independent axis, and I avoid using them. Previous versions of Excel
have
made it very easy to unwittingly create useless "scatterplots" using the
line
chart function. I haven't tried them on this version (2007). I've been
told
recently they handle time-series data okay, though I've never looked into
it,
having previously been satisfied with the scatterplot function. Thanks,
I'll
have a look.

Still, I would like to see Microsoft bring Excel back up to its previous
level of usefulness. Why would they disable something like that? It
makes
no sense...


"Bernard Liengme" wrote:

A quick experiment confirmed your problem. Would a Line chart work for
you?
The problem goes away and Line charts are appropriate for time series
charts.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JRS" wrote in message
...
I work for an environmental engineering firm, and commonly create
time-series
and other scatterplots of numerical data using Excel.

In Excel 2003, I could format a time-series scatterplot axis minimum
and
maximum easily by typing in the dates in short date format. Not so in
2007 -
it refuses to accept dates in anything but "days elapsed since
01/01/1900"
format.

Is there a workaround for this? Why was it changed? It was quite
useful.

Overall, I'm pretty unhappy with the new Excel. It seems to have
acquired
a
lot more layers of very questionable usefulness. Many of the new
features
in
the graphing (charting) function would be a lot more at home in
Powerpoint
than in a bread-and-butter engineering program like Excel. Most of
the
changes seem to be of the "because we can" variety rather than having
been
driven by any real need or user feedback.

Thanks,

JRS