Hi,

Named ranges are usually to be preferred, and if you're wanting to express the number of occurrences of something in a chart then one way or another you'll need to establish the count of such things.

There are basically two options, using a function like COUNTIF() or using a Pivot Table, and on the back of the PT a Pivot chart. For more detailed help you'll need to upload the workbook in question.