If you like the nice formatting options of the Line Chart's time axis, keep
the first series as a line chart. Make sure the axis is formatted with the
base unit in days. Add the second series, convert it from line to XY type
(Chart menu: Chart Type), then while ignoring the funky new secondary axes,
double click on the new series, and on the Axis tab, choose Secondary.

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

"Mona" wrote in message
...
thank you, xy scatter works!!

"David Biddulph" wrote:

"Mona" wrote in message
...
I am using a line chart with 2 + series using dates on the x axis. For
example:

01/05/2005 200
01/06/2005 300
01/07/2005 400
01/08/2005 500
01/09/2005 600
01/10/2005 700

I want to add an additional series from a separate worksheet that has
example data:

01/08/2005 1000
01/09/2005 2000

My question is how do I plot the second series so that the date plots
correctly. If I try to plot the second series it will plot using:

01/05/2005 1000
01/06/2005 2000

I was hoping to not add additional rows of dates. Thanks!

You need to make sure that you are using an X-Y (scatter) graph, not a
line
chart.
When you add each series of data, make sure that you include the dates as
your X axis values.
--
David Biddulph