I have a typo:
Instead of

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


"Mona" wrote:

I might be missing something ??

When I do as you suggested the 2nd series plots as
01/05/2005 1000
01/06/2005 2000

Instead of

01/08/2005 1000
01/06/2005 2000

I want my graph to plot 01/01/2005 through 01/10/2005.

thanks!

"Kelly O'Day" wrote:

To add the 2nd series, select your chart. Chart menu should now be visible
on top menu

1. Goto Chart menu
2. Select Source Data
3. Select Series
4. Press Add Series choice
5. Enter series ranges

You should now have the 2nd series.




"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!