Add a column header for column B. Then, create a PivotTable (and
corresponding PivotChart) using it as the data source. In the PT, put
column B as the row field and the data field. If XL gives you a 'Sum
of column B' in the data field, double-click the data field and change
the sum to count.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have data that looks like th following

A B
01/08/05 4009 How do I get Excel to calculate how often each
number
01/15/05 4179 was presented in a chart to look like the
following
01/15/05 5140
01/22/05 4009 3
01/31/05 4009 2
1
4009 4179 5140
Job Number

Help Please.