From: trip_to_tokyo on 30 Apr 2010 09:34
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.
Next: How do you get rid of the outside edge with the numbers and lette.