How can I plot data such as below so that dates come out in their proper
location on the x axis?


Date DJIA
01/31/07 12,622
02/27/07 12,216
04/20/07 12,962
05/25/07 13,150
05/18/07 13,556



Thx

Dave

On Fri, 17 Aug 2007, in microsoft.public.excel.charting,
Dave said:
How can I plot data such as below so that dates come out in their proper
location on the x axis?

Date DJIA
01/31/07 12,622
02/27/07 12,216
04/20/07 12,962
05/25/07 13,150
05/18/07 13,556

If you're using a Line, Area, or Column chart type, it should have
detected the presence of dates and auto-selected the Time-scale X axis
instead of a category X axis. You can manually select Time-scale axis
in the Chart.. Chart Options.. Axes menu.

Alternatively, you can change to an XY (Scatter) type, and format the
data series with lines like a Line chart. The XY chart has a Value X
axis.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Thanks Del - that got it!
Dave


"Del Cotter" wrote in message
...
On Fri, 17 Aug 2007, in microsoft.public.excel.charting,
Dave said:
How can I plot data such as below so that dates come out in their proper
location on the x axis?

Date DJIA
01/31/07 12,622
02/27/07 12,216
04/20/07 12,962
05/25/07 13,150
05/18/07 13,556

If you're using a Line, Area, or Column chart type, it should have
detected the presence of dates and auto-selected the Time-scale X axis
instead of a category X axis. You can manually select Time-scale axis in
the Chart.. Chart Options.. Axes menu.

Alternatively, you can change to an XY (Scatter) type, and format the data
series with lines like a Line chart. The XY chart has a Value X axis.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.