I need a little help here. I've got a spreadsheet with revenue figures,
which my boss would like graphed (obviously) using a multi line
graph(not bar graph). A sample set of data looks as follows:
Year Week Revenue
2001 3 12345
2001 4 56423
2002 1 6546
2002 4 46546
etc.
Now, here's the catch... they want 1 trend line for each year. So, for
2001, a graph from week 1 - 52 of the revenues, same for 2002, same for
2003.
Any thoughts?
--
mdfrew
------------------------------------------------------------------------
mdfrew's Profile:
http://www.excelforum.com/member.php...o&userid=34163
View this thread:
http://www.excelforum.com/showthread...hreadid=539273