G
Guest
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/com...f6750a83fe&dg=microsoft.public.excel.charting
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/com...f6750a83fe&dg=microsoft.public.excel.charting