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/
_______


"feirin" wrote in message
...