zip code help!

  • Thread starter Thread starter cbender3
  • Start date Start date
C

cbender3

hi there,

i am beginning to get frustrated so i thought maybe you could help me

i have a series of lead calls from zip codes i'd like to chart. Th
following is a sample

33111
33111
33122
31333
33144
33155
33155
33155

Now here is the problem: When i chart the series i see multiple 3311
single 33122, 33, 44 and multiple 33155's

How do i get the chart to represent a bar with value of 2 for 3311
value of 1 for the others and a value of 3 for 33155?

your help is appreciate
 
You can summarize the data with a Pivot Table, and create a chart from that.

Add a heading cell to the top of the list, e.g. ZipCode
Select a cell in the table
Choose Data>PivotTable and PivotChart Report
Select PivotChart report (with PivotTable report), click Next
Select the Data range, click Next
Click Layout
Drag the ZipCode button to the Row area
Drag ZipCode again to the data area, where it will become
Count of ZipCode
If it is Sum of ZipCode, double-click on the button, and choose
to summarize by Count
Click OK, click Finish
 
You need to have a list of the UNIQUE numbers and then use a countif formula
a b
33111 =countif(yourrange,a2)
etc
then graph that
 
Back
Top