I have the current excel sheet (but it goes on for 600 more rows). How do I take information or certain columns/rows out and make a new chart while leaving the existing one? I am needing to break each different project #/section into its own charts to compare all the projects to one another analyzing which one is the best for a small business to invest into for phase two of a project.

 

A B C D 3 LOT # PROJECT # ASK PRICE SELL PRICE $102,500 $105,000 $79,900 $78,000 $75,700 $72,000 $84,500 $80,000 $70,000 $69,850 $79,900 $79,000 $77,500 $70,900 $74,500 $96,800 $94,500 $103,000 $75,600 $79,900 $77,800 $78,000 $81,500 $72,000 $67,850 $92,500 78 7878 78 SAFETERIANX~~~~~~8588888888 123456789012345678920122 232324 25 25 26 26 27 27 28 28 25 25 30 30 11 32 32 33 33 34 34 35 37 2382378237823 23823 238238233 23 142 43 44 45 46 47 48 45 4 6 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 49 29 29 31 31 78 78 78 78 78 78 78 78 78 78 78 23 78 78 78 78 78 78 78 78 78 $87,900 $79,900 $93,500 $83,400 $108,000 $94,500 $94,000 $88,900 $80,000 $71,500 $70,000 $79,900 $79,900 $69,900 $95,000 $69,900 $79,900 $73,500 $72,500 $75,000 $94,500 $85,600 $104,500 $84,500 $91,500 $101,000 $69.900 $69,800 $92,500 $90,000 $100,000 $69,800 $77,700 $75,000 $74,850 $79,600 $69,000 $64,890 $91,000 $84,250 $77,890 $89,460 $81,380 $106,000 $92,000 $94,000 $87,900 $80,000 $69,280 $70,000 $78,000 $79,000 $67,500 $94,350 $68,700 $79,800 $70,000 $71,000 $72,000 $93,000 $83,000 $104,000 $79,250 $90,000 $101,000 $67.000 E F H LIST DATE SALE DATE SQ. FT. #BATH. #BDRMS 29-Jul-11 23-Oct-11 1900 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 29-Jul-11 01-Jun-11 29-Jul-11 29-Jul-11 01-Jan-11 29-Jul-11 01-Jan-11 29-Jul-11 01-Jan-11 29-Jul-11 01-Jan-11 29-Jul-11 01-Jan-11 29-Jul-11 01-Jan-11 29-Jul-11 01-Jan-11 29-Jul-11 01-Jan-11 29-Jul-11 01-Jan-11 29-Jul-11 01-Jan-11 29-Jul-11 01-Jan-11 21-Oct-11 1450 03-Nov-11 1350 31-Aug-11 1600 31-Oct-11 1300 10-Nov-11 1500 18-Nov-11 1300 04-Oct-11 1300 24-Oct-11 1700 02-Oct-11 1750 20-Oct-11 1850 14-Oct-11 1350 09-Oct-11 1450 12-Aug-11 1450 04-Nov-11 1450 30-Oct-11 1450 07-Nov-11 1350 18-Nov-11 1250 20-Nov-11 1750 11-Nov-11 1557 13-Nov-11 1450 30-Oct-11 1650 21-Jul-11 1500 08-Dec-11 2000 02-Nov-11 1750 10-Apr-11 1775 04-Oct-11 1600 15-Apr-11 1525 24-Oct-11 1300 19-Mar-11 1300 02-Oct-11 1500 30-Apr-11 1500 20-Oct-11 1300 05-May-11 1750 14-Oct-11 1300 30-Mar-11 1500 09-Oct-11 1300 25-May-11 1300 12-Aug-11 1450 15-May-11 1700 22-Mar-11 04-Nov-11 1550 1900 30-Oct-11 1450 10-Apr-11 1750 07-Nov-11 1900 18-Apr-11 1350 22535-N35255 1.75 N 2.5 1 1.75 2.25 2.5 1 3 2.25 2.25 2 1 3 2.25 2.5 2 2.5 2.25 3 2.25 2.5 2.25 1 2.25 5253 2 2.5 1 1.75 3 2 2.25 2.25 2.25 2.5 IN 2 www. 3 2.25 4 SAAWANGWAWWA. 4 3 4 3 5 2 4 3 4 4 4 3 4 4 4 4 3 4 4 4 3 4 3 4 3 4 4 4 4 3 4 4 4 3 4 WWWANA 2 3 3 3