charting 2 sets of dates against each other

[gordon_conroy]

HI
I have 2 sets of data(AB and CD),I've included a sample below
A contains the date the ticket was opened and B contains the numbe
opened on that date.
C contains the date it was closed and the total closed on that date
What I need is to plot AB against CD(preferable on a 2 line char
type)
The main problem I have is that the dates are no in sequence

Any suggestions appreciated
Thanks,
Gordon

A B C D
7/01/2003 2 8/01/2003 1
9/01/2003 6 14/01/2003 2
10/01/2003 7 15/01/2003 4
13/01/2003 8 28/01/2003 6
14/01/2003 10 29/01/2003 8
15/01/2003 16 30/01/2003 10
16/01/2003 18 31/01/2003 13
17/01/2003 20 3/02/2003 16
21/01/2003 21 4/02/2003 19
22/01/2003 23 7/02/2003 23
28/01/2003 26 11/02/2003 24
29/01/2003 27 18/02/2003 28
30/01/2003 31 19/02/2003 3

 

[Jon Peltier]

It's not even necessary to move the data if it's an XY chart. Make an XY
chart with A and B, then copy C and D, select the chart, and choose
Paste Special from the Edit menu, with the New Series and Categories in
First Column options.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Hi Gordon,

If you rearrange you data so that C and D are appended to A and B.
Then move The values that were in D across to C.

You should then be able to select the 3 columns of data and create an
XY-scatter.

Cheers
Andy