Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Location
    Dallas, Texas, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    New Lounger
    Join Date
    Sep 2003
    Location
    Dallas, Texas, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •