Line chart from data in 2 sheets

F

Freightliner

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top