View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Paddy
 
Posts: n/a
Default How to chart a single column of values similar to a GROUP BY

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