Excel Graphing help

[AidanEnos]

Okay, I have a spreadsheet that has data exampled below. What I'm graphing is the date on X-axis and litres on the Y-axis.

Now the data, as you can see, is centric around 2 vehicles - what I'd like to do is tell the line graph that series 1 should filter the data on column A and look for row entries with Escort and graph that, then series 2 should filter on column A and look for row entries with Montana.

Now, I know I can do a manual sort on the coulmn and graph the data, and I could make 2 new tables and have them parse the database and graph each vehicle seperately. But I'm looking for a way to keep my database in tact and tell the Source Data line in the graphing tool to parse the database.


Montana September 6, 2001 67.701 14.892 $0.709 bronze $56.00 585.3 km 363.7 mi 24.42 mpg 11.57 l
Escort September 7, 2001 40.051 8.810 $0.699 bronze $28.00 598.9 km 372.1 mi 42.24 mpg 6.69 l
Montana September 13, 2001 68.085 14.977 $0.705 bronze $48.00 594.5 km 369.4 mi 24.67 mpg 11.45 l
Escort September 14, 2001 37.730 8.299 $0.689 bronze $26.00 589. km 366. mi 44.1 mpg 6.41 l


Thanks,

 

[ETID]

Assuming that this data has field headings, you could use the pivot chart to display your data...