here are some screenshots to show what Im doing...

I want to take this Pivot table...

http://img361.imageshack.us/img361/6603/pivoteq5.jpg

and have a macro take those top ten vendors, and create 10 seperate charts like this...

http://img386.imageshack.us/img386/397/chartns3.jpg


Any ideas? you dont have to code it for me, just point me in the right direction, I like to consider myself a fairly fast learner :P