Graphing multiple lines of the same data for yearly comparison

[Brian]

I have imported data from Access into Excel to make some
line graphs. The data is monthly for multiple years and
I am wanting to graph the data for each year separately
on the same graph for some comparisons. The only thing I
have been able to do so far is to graph the data for all
years on one line. Please advise. Thank you.

Brian

 

[Debra Dalgleish]

Set up your data with Months across the top and years down the first
column. For example:

Jan Feb Mar
2002 63 21 19
2003 91 26 79
2004 63 63 43

Select a cell in the table, and click the chart wizard button on the
toolbar.