Line chart from data in 2 sheets
 

Hi,

Sheet2010 stores data for year 2010

Date Gross Net
1/8/2010 2076.92 1163.98
1/8/2010 5000.00 2862.51
1/22/2010 2076.92 1511.99
2/5/2010 2307.69 1302.92
2/19/2010 2307.69 1302.91
3/5/2010 2745.25 1566.36
3/19/2010 2884.62 1648.08
4/2/2010 2838.62 1621.31
4/16/2010 2884.62 1648.08

Sheet2009 stores data for year 2009

9/18/2009 2276.35 1333.82
10/2/2009 2048.72 1194.39
10/16/2009 2048.72 1194.39
10/30/2009 2048.72 1173.29
11/13/2009 2111.40 1211.69
11/27/2009 2076.92 1190.56
12/11/2009 2076.92 1190.57
12/25/2009 2076.92 1190.56


I'd like to create a line chart having X-axis the dates of both years
and gross and net as the two data series.

Thank you for help

Line chart from data in 2 sheets
 

Hello,

Jon has several approaches illustrated on his site - probably the easiest is
to create a summary sheet:

http://peltiertech.com/Excel/ChartsH...iffSheets.html

--
John Mansfield
http://www.cellmatrix.net


"Freightliner" wrote:

Hi,

Sheet2010 stores data for year 2010

Date Gross Net
1/8/2010 2076.92 1163.98
1/8/2010 5000.00 2862.51
1/22/2010 2076.92 1511.99
2/5/2010 2307.69 1302.92
2/19/2010 2307.69 1302.91
3/5/2010 2745.25 1566.36
3/19/2010 2884.62 1648.08
4/2/2010 2838.62 1621.31
4/16/2010 2884.62 1648.08

Sheet2009 stores data for year 2009

9/18/2009 2276.35 1333.82
10/2/2009 2048.72 1194.39
10/16/2009 2048.72 1194.39
10/30/2009 2048.72 1173.29
11/13/2009 2111.40 1211.69
11/27/2009 2076.92 1190.56
12/11/2009 2076.92 1190.57
12/25/2009 2076.92 1190.56


I'd like to create a line chart having X-axis the dates of both years
and gross and net as the two data series.

Thank you for help


.