Graphing multiple lines of the same data for yearly comparison

  • Thread starter Thread starter Brian
  • Start date Start date
B

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
 
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.
 
Back
Top