A chart with sums and averages

[NCYankee1]

Hi!

In Access 97 I need to create a chart that looks like, well here is a mockup I did (I am not a good graphical artist):

http://www.ncyankee.com/samples/graphsample.jpg

On that sample, the blue lines are sums by person. The red lines are the average for the people on that team. I know I can put together a query with this data all prepared. Like this:
Jeter 60
Williams 55
O'Neill 47
New York 54
Everett 45
Ramirez 62
Nomar 10
Boston 39
..where the New York row is the average of Jeter, Williams and O'Neill and the Boston row is the average of Everett, Ramirez and Nomar. BUT how would I represent the "average" rows as a different color bar than the individual people's bar in the chart? Like in my example.

Any help would be greatly appreciated!
Thanks!

 

[NCYankee1]

FYI, I did devise a solution to this problem. I don't know if it is smart or just a Rube Goldberg, but here is what i did to put sums and averages intermingled on the same bar chart:

I wrote a number of queries, that in the end combined the summation data and the averages data into a temp table that looked like this:
Name
Sum
Average
On the rows where I wanted the sums to be shown on the chart, I made the average field null. On the ones where I wanted to post the average as a bar I nulled out the sum. I made the bars for "sum" one color and the bars for the average another.