date axis

[Guest]

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!

 

[Kelly O'Day]

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.

 

[Guest]

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]

I suggest that you use an XY (Scatter chart). My previous post works well
with your data for an XY chart, it doesn't work with a line chart.

 

[David Biddulph]

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.

 

[Guest]

I have a typo:
Instead of

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

 

[Guest]

thank you, xy scatter works!!

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.

 

[Jon Peltier]

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/
_______