+ Reply to Thread
Results 1 to 2 of 2

Chart w/ 2 drop downs! Help me out please!

  1. #1
    Registered User
    Join Date
    03-12-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Chart w/ 2 drop downs! Help me out please!

    I've attached the spreadsheet that I'm working on and I actually need it for work tomorrow morning. So please help me out if you can!

    At the top, I've created a graph with a dropdown of providers. As you can see, it populates the table right below the graph and it pulls data from right below there. No problem there. Well, I was asked to do this but being able to break it out by both Provider and Month. So I need to be able to select Provider & a month! Starting at line 60, below the black line, I started working on it, but I cant figure it out. Below that is all of the data (provider, month, each code in Signature, each code in Allscripts). In the graph, I need to see 3 lines when I select a provider--- Signature, Allscripts, Average. Can you please help me out??? I would really appreciate it.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Chart w/ 2 drop downs! Help me out please!

    Hi

    Have a look at the attached. I've changed the way the drop downs select the data, so hopefully that will give you some hints.

    rylo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1