SO I'm trying to put 2 different series on the same graph with different
chart types. One series as a line plot and one as a scatter XY. I put the
first series in a line chart because it's lets me use equally spaced dates on
the x-axis, and then the second series is in scatter plot.

This has worked fine up til now: For some reason, Excel wants to plot the
data from the second series far in the future (the year 4300), while the
first series plots fine. (all data is in dates between 1977 and 2003).
There are no mistypings, and I even played with the cell formats to see if
there was something hidden, but no luck. Any ideas?

A clue?: At first it tried to include a lattitude value I had mistakenly
included (it was treated as a serial, which equaled the year 5000 or
something), but even now that I've deleted that row and pasted the correct
information in a new sheet, I'm getting the same error.

Thanks.

PS - here is my data:

Series 1
8/24/1979 436
3/13/1981 424.8
10/27/1981 431.6
3/8/1982 421.7
10/27/1982 434.9
3/16/1983 424.2
8/30/1983 437.1
2/28/1984 425.3
10/1/1984 482
2/20/1985 453
3/20/1985 456
2/19/1986 552
11/13/1986 486.3
11/3/1987 547
2/18/1988 504
11/2/1988 555
3/29/1989 511
10/26/1989 551
3/3/1990 516
3/15/1994 550.6
3/16/1995 588
3/13/1996 572
3/21/1997 544
3/11/1998 550
3/10/1999 559
3/15/2000 550
3/8/2001 526

Series 2

5/17/1977 375
3/13/1981 366
10/29/1981 339
2/25/1982 332
10/27/1982 338
3/11/1983 340
8/30/1983 337
2/29/1984 333
3/13/1985 326
10/4/1985 334
3/8/1986 327
2/8/1988 334
3/29/1989 356
3/28/1990 334
3/13/1991 337
3/11/1992 342
5/13/1997 375
10/26/1999 342
8/30/2000 360
8/17/2001 362
3/8/2002 333


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

Hi,

The problem is the mixing of dates and categories.

Your line charts is plotting each point equi distance with the x values of 1
to 27, which is what you want.
However when you add the xy-scatter the dates are converted in to values
where
17-April-1977 is 28262
8-March-2002 is 37323

So you line chart is squashed to the left and your xy scatter is squashed to
the right.
Using the secondary X and Y axis is probably the most sensible thing to do.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Morgs" wrote in message
...
SO I'm trying to put 2 different series on the same graph with different
chart types. One series as a line plot and one as a scatter XY. I put
the
first series in a line chart because it's lets me use equally spaced dates
on
the x-axis, and then the second series is in scatter plot.

This has worked fine up til now: For some reason, Excel wants to plot the
data from the second series far in the future (the year 4300), while the
first series plots fine. (all data is in dates between 1977 and 2003).
There are no mistypings, and I even played with the cell formats to see if
there was something hidden, but no luck. Any ideas?

A clue?: At first it tried to include a lattitude value I had mistakenly
included (it was treated as a serial, which equaled the year 5000 or
something), but even now that I've deleted that row and pasted the correct
information in a new sheet, I'm getting the same error.

Thanks.

PS - here is my data:

Series 1
8/24/1979 436
3/13/1981 424.8
10/27/1981 431.6
3/8/1982 421.7
10/27/1982 434.9
3/16/1983 424.2
8/30/1983 437.1
2/28/1984 425.3
10/1/1984 482
2/20/1985 453
3/20/1985 456
2/19/1986 552
11/13/1986 486.3
11/3/1987 547
2/18/1988 504
11/2/1988 555
3/29/1989 511
10/26/1989 551
3/3/1990 516
3/15/1994 550.6
3/16/1995 588
3/13/1996 572
3/21/1997 544
3/11/1998 550
3/10/1999 559
3/15/2000 550
3/8/2001 526

Series 2

5/17/1977 375
3/13/1981 366
10/29/1981 339
2/25/1982 332
10/27/1982 338
3/11/1983 340
8/30/1983 337
2/29/1984 333
3/13/1985 326
10/4/1985 334
3/8/1986 327
2/8/1988 334
3/29/1989 356
3/28/1990 334
3/13/1991 337
3/11/1992 342
5/13/1997 375
10/26/1999 342
8/30/2000 360
8/17/2001 362
3/8/2002 333


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting