From: trip_to_tokyo on
EXCEL 2007

Kyle, you seem to need a Pivot Table and Chart.

Take a look at:-

Item Number 98.

If you pull this up on the screen in front of you you can flip information
into and out of the chart by, in this example, toggling the Row Labels
switch. This seems to give you the type of flexibility you need.

If my comments have helped please hit Yes.