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.

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.

Jacquie -

I put your data into a table like this, with headers:

Date Job No.
1/8/2005 4009
1/15/2005 4179
1/15/2005 5140
1/22/2005 4009
1/31/2005 4009

I used it to make a pivot table (on the Data menu). I dragged the Job
No. field to the rows area and to the data area. This gave me a table
like this, which isn't useful:

Sum of Job No.
Job No. Total
4009 12027
4179 4179
5140 5140
Grand Total 21346

But I double clicked on the cell that says Sum of Job No. and in the
Summarize By listbox, I selected Count. Here's what I got:

Count of Job No.
Job No. Total
4009 3
4179 1
5140 1
Grand Total 5

Now your data is ready to plot.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Jacquie wrote:

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.