http://www.excelforum.com/excel-char...eto-chart.html

this OP says that she really wants a pivot table solution. I expect it can be done, but I have no experience with pivot tables. I think the solution I proposed will work, but, if anyone who knows pivot tables could chime in and show her how to do it with a pivot table/chart, it could be a better solution.