# Thread: One Table - Multiple Charts (Excel 2003)

1. ## One Table - Multiple Charts (Excel 2003)

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! [img]/forums/images/smilies/smile.gif[/img]

2. ## Re: One Table - Multiple Charts (Excel 2003)

Do you really need all the separate charts, or would it be ok to have - for example - a dropdown list from which the user selects a sales representative, and all charts will display the data for that sales rep?

3. ## Re: One Table - Multiple Charts (Excel 2003)

The end product of these tables are going to be posted on our company Rep Room, and each rep will only be able to see their own numbers. The problem that I have is getting them on the web and only allowing the people to see their own individual chart.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•