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.
Bookmarks