Macros and Charts

I'm looking to create a macro that brings up a bar graph automatically (so that you don't have go through the Wizard and all that). That's the easy part.

I'm also looking for a way to count a specific number of names to put in that chart. Example: I have a column entitled Supplier Name. I want the chart to take all of the names in the column, add them up and then put them on the bar graph. So for instance, Name A appeared 10 times in the column, it would be counted automatically and then put into the graph. Name B appeared 12 times, that would be counted and put into the graph and so on.

Also, only the top 7 Names would be recorded in the graph. Maybe what I'd have to do is have a seperate (maybe hidden?) column that adds up the names and places them in numeric order, then have the graph pull from these numbers, but I'm not sure how to go about doing that, nor am I sure how to set the macro up.

Ok, I've added an attachment. I'm new to the boards and it didn't let me attach the excel file, so I took a screenshot of the data and put it into a word document. I'll explain the file a bit.

As you can see, I've only filled out the Supplier name column for this, because for now its all I need. Again, I need to find some way to add up of the names and then create a bar graph for the data using a macro of some sort.

EX)
ACI Electronics - 1
Actel - 2
Advanced Graphics - 4
Aeroflex Laboratories - 2
Alcoa Global - 2
Anixter Pentacon - 2
API Deltran - 1
Arrow Electronics - 2
Advanced Inustries - 1
Beaver - 1

And again only the top 7 would get addressed in the graph. Thanks in advance.

Ah I gotcha. Ok, the information is different now (the supplier name column I mean) but here is the zipped file

Wow that's brilliant. Thank you so much. A few follow-up questions though, if you don't mind.

First of all, can you give me an idea of what's going on in this code? Just a little explanation? I'm trying to learn VBA as best as can on the fly sort of, and that code confuses the crap out of me. Also, is there anything you should absolutely not do? Something that blows up the code so to speak? I'm just asking because this isn't meant for me, but for a few other people in the company I work for, one of them my boss.

Also, is there any way to populate the X axis of the chart with the actual names of the supplier?

Now also for some reason I get a Method 'Cells' of object global failed error. I didn't think I did anything to affect it but apparently I did.

It's on this line:
For N = 11 To Cells(65536, 3).End(xlUp).Row

It helped a ton. Thanks again.