Hello,

I want to chart two series of data on the same line chart. I have a field
entitled "term" for which I want a line for each term. I have a date field
entitled "x" and number field entitled "y". The only difficulty is I have
two separate sets of data with differing x (or date) axis.

How do I chart such data? Excel will only allow me to use on of the x axis
or the other.

I would like to chart the data below.

TermApp,x,y
061,01/05/2005,1
061,01/05/2005,2
061,01/12/2005,3
061,01/12/2005,4
061,01/12/2005,5
061,01/12/2005,6
061,01/12/2005,7
061,01/12/2005,8
061,01/12/2005,9
061,01/12/2005,10
061,01/12/2005,11
061,01/12/2005,12
061,01/21/5200,13
061,01/26/2005,14
061,01/26/2005,15
061,01/26/2005,16
061,01/26/2005,17
061,01/26/2005,18
061,01/26/2005,19
061,01/26/2005,20
061,01/26/2005,21
061,01/26/2005,22
061,01/26/2005,23
061,01/26/2005,24
061,02/01/2005,25
061,02/02/2005,26
061,02/02/2005,27
061,02/02/2005,28
061,02/02/2005,29
061,02/02/2005,30
061,12/15/2005,31

TermApp,x,y
053,01/05/2005,1
053,01/12/2005,2
053,01/12/2005,3
053,01/19/2005,4
053,01/26/2005,5
053,01/26/2005,6
053,02/02/2005,7
053,02/02/2005,8

Thank you for your time and efforts.

Sincerely,

Christopher Jon Jursa

Christopher -

Plot the data as two separate XY Scatter chart series, not as Line
series, and they should appear just fine on the single X axis.

There's a likely typo in point 13 of the first set, I doubt you want
1/21/5200.

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

Christopher Jursa wrote:

> Hello,
>
> I want to chart two series of data on the same line chart. I have a field
> entitled "term" for which I want a line for each term. I have a date field
> entitled "x" and number field entitled "y". The only difficulty is I have
> two separate sets of data with differing x (or date) axis.
>
> How do I chart such data? Excel will only allow me to use on of the x axis
> or the other.
>
> I would like to chart the data below.
>
> TermApp,x,y
> 061,01/05/2005,1
> 061,01/05/2005,2
> 061,01/12/2005,3
> 061,01/12/2005,4
> 061,01/12/2005,5
> 061,01/12/2005,6
> 061,01/12/2005,7
> 061,01/12/2005,8
> 061,01/12/2005,9
> 061,01/12/2005,10
> 061,01/12/2005,11
> 061,01/12/2005,12
> 061,01/21/5200,13
> 061,01/26/2005,14
> 061,01/26/2005,15
> 061,01/26/2005,16
> 061,01/26/2005,17
> 061,01/26/2005,18
> 061,01/26/2005,19
> 061,01/26/2005,20
> 061,01/26/2005,21
> 061,01/26/2005,22
> 061,01/26/2005,23
> 061,01/26/2005,24
> 061,02/01/2005,25
> 061,02/02/2005,26
> 061,02/02/2005,27
> 061,02/02/2005,28
> 061,02/02/2005,29
> 061,02/02/2005,30
> 061,12/15/2005,31
>
> TermApp,x,y
> 053,01/05/2005,1
> 053,01/12/2005,2
> 053,01/12/2005,3
> 053,01/19/2005,4
> 053,01/26/2005,5
> 053,01/26/2005,6
> 053,02/02/2005,7
> 053,02/02/2005,8
>
> Thank you for your time and efforts.
>
> Sincerely,
>
> Christopher Jon Jursa
>
>