Results 1 to 1 of 1

Dynamic Chart with multiple drop downs vba code

Threaded View

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    1

    Dynamic Chart with multiple drop downs vba code

    Hi

    I need to create a excel macro for creating dynamic charts. In essence i will have data in Sheet1 of my workbook (column 1 will be time, col2 sales, and col3 onwards the media investments) and when i run the macro it should activate Sheet2 and in that provide two drop downs with all the series names in each drop down. i would wat a macro that plots any two series names as in the two drop downs with timeperiod on the x axis in the same sheet. so for example if in first drop down i select sales and in second tv invesment i get a line chart with time on x axis and sales and tv investment on the y axis....

    any help in this regard would be greatly appreciated. please find attached the data for the same. Notice the Data length (columns can vary)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamic Cascading Drop-Downs Using INDEX & MATCH
    By GeneralDisarray in forum Excel Tips
    Replies: 4
    Last Post: 09-06-2017, 11:13 AM
  2. Replies: 7
    Last Post: 11-30-2012, 01:23 PM
  3. [SOLVED] Dynamic dependant VBA drop downs
    By questionguy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-10-2012, 04:20 PM
  4. Chart w/ 2 drop downs! Help me out please!
    By rocket324 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2012, 10:00 PM
  5. Replies: 0
    Last Post: 07-19-2006, 01:30 PM

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