Multi series graphs

[E Gish]

I have a theoretical question. I am spinning my wheels right now at work

I will use the widget metaphor to describe my process

I am graphing the total number of widgets that are inventoried in several districts around the country using a bar graph. My database has several products in them, of which widgets are only a part of them. So I enter the table view, and do a find on the wigets and group them and do a count by sorting. Then go to my graph and display the results. Everythign looks nice so far.

I then want to display another graph along side of them, showing how many of a certain type of widgets I have... lets just say YELLOW widgets... vs the over all total per district... aka what I think would be another series of data

How do I do a 2nd found set for another graph series along side the 1st found set series?

and thus a 3rd set..., etc...

[E Gish]

making a field which is a calculation that totals the 2nd series, which is a subset of the 1st, then adding it as a 2nd series on the graph works perfectly