Making a chart

[Intelly One]

I know exactly what you need. You need a pivot table to
sort all the data for you. You can find the data needed
by the certain categories. In your example you have to
highlight your data, click "Data" on the toolbar,then
click pivot table, then click next, click next again,
and click finished. Once you've done that drag the 13
categories onto the "drop rows here" from the pivottable
field list and then drag the numbers in the "drop data
here" section. Finally drag again the data(your numbers)
from the pivottable field list to the "drop page fieds
here section" From there click the drop down box, select
the number of which you want all to be displayed. That
should do it! Go Bulldogs!

-----Original Message-----
I am trying to make a chart from the info off of my

excel spreadsheet, which is a log of all incidents. . I
am taking info from 2 different columns. One column is
the location of the incident and the second is the code #
of the incident. There are only 3 different code #â?Ts,
but there are 13 different locations of incidents.

What I want the chart to tell me is how many of each

code happened in each location. For example..there are 66
different incidents where a 901 code was used. I would
like a break down of how many 901â?Ts were in each
location.