Prev: Copying Excel 2007 Charts as picture (as seen on screen)
Next: Excel Chart
From: Freightliner on 16 Apr 2010 15:28
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


From: John Mansfield on 17 Apr 2010 09:32
Hello,

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

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.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
>
>
> .
>
 | 
Pages: 1
Prev: Copying Excel 2007 Charts as picture (as seen on screen)
Next: Excel Chart