Hi Greg

Thanks, worked great.

One further question on this. Col A will have any number of entries. Is
there a way for me to get a "distinct" list of the values contained in it for
use in Col B

Thanks

Paddy

"Greg Wilson" wrote:

Assuming the list of colours are already entered in Range("A1:A100") then:
1. In cell B1 enter Blue
2. In cell B2 enter Brown
3. If there are more colours then continue entering (B3, B4... etc)
4. In cell C1 enter: "=CountIf($A$1:$A$100, B1)"
5. Drag the formula down to the end of the list in column B (C2 if only two
colours)
6. Select the cells containing the colour list and formulas (cols B and C)
and plot them as a Column chart

If the colour list in column A is variable in length then I think I would go
with a Dynamic Named Range in place of "A1:A100". If not familiar I can
describe.

Regards,
Greg





"Paddy" wrote:

Hi

I would like to create a chart of a column of non numeric values where the
column label would be the value and the chart would reflect the number of
occurences of the value in the column eg.

brown
blue
blue
brown
brown

this would produce two bars on the chart labled brown and blue with values
of 3 and 2 respectively.

It is the same as a GROUP BY function in SQL

Any help is really appreciated.

Thanks

Paddy