Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
line chart with separated X data | Charts and Charting in Excel | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
Copyin multiple sheets data into one line | Excel Worksheet Functions | |||
Chart sheets cause data sheets to be blank | Charts and Charting in Excel |