Use a pivot table or use some kind of COUNTIF formulas to compile the data
into a list of item and frequency, then construct the chart based on this
calculated data.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______