I know how to do the task I need to do the long way, but I’m looking for a way to do the task an easier way.
I have attached a spreadsheet to this post. It has four tables included on it. The first is basic sales, the second is cumulative sales, the third is run rate, and the fourth is run rate * 10%. My boss’s definition of Run Rate Per Month is All Sales/Months reported. In other words, if the total sales from Jan-Jun is $600,000, then the Run Rate Per Month would be $100,000. Then the first month’s Cumulative Run Rate is Run Rate per Month*1, then the second month is Run Rate Per Month *2, etc. (I’ve never used a formula like this, if anyone knows of a built-in Excel formula that will do this I’d love to use it.)
Now, here’s the problem. I have over 100 sales reps which I’m calculating these totals for and charting. The calculating is not so complicated. However, creating 100+ charts a month is a rather daunting task. Can anyone think of a macro or an easy way to create this table? Eventually, the sales are going to be in a pivot, and I can update the pivot which should update all the other tables, which will update the charts. I just want to know if anyone knows a shortcut to making a ton of charts at once.
Thanks for any assistance you can offer! 
