I don't know how the dropdown relates to your data. In general you need some
kind of list, with the source type in the first column and the count in the
second. If what you have is just a long list of lead source types that you
need to compile, you could follow one of the approaches on this page:

http://peltiertech.com/Excel/ChartsH...idateData.html

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


"Eric" wrote in message
...
I have a spreadsheet which contains a drop down box that has different lead
sources (Phone Book, Internet, Postcard Mailer, etc)

The x-axis should have the lead source type (found in [table column 1]),
and
the y-axis should have the number of times that lead source was found in
[table column 1]

Any help would be greatly appreciated.

Thanks,

Eric