"mdfrew" wrote in
message ...

Anyone?? I get back to the office on Friday and need to help him
prepare this graph

If your data is sorted by year, select the week & revenue columns for the
rows in the first year (2001), insert the graph (XY scatter), & label the
series as 2001 (or point the series name in the source data at one of the
cells containing the 2001 label), then select the week & revenue columns for
the second year rows (2002), copy, edit, paste special, new series, label
that series 2002, and so on.

[Note that you'll be more likely to get a response if you include in your
message some of the context to which you are replying. Most people reading
your message above won't have a clue what your original question was.]
--
David Biddulph