+ Reply to Thread
Results 1 to 3 of 3

Dynamic chart based on three dropdown menus.

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    Delft
    MS-Off Ver
    2007
    Posts
    2

    Dynamic chart based on three dropdown menus.

    Dear all,

    It is very hard to create a dynamic chart which is based on multiple dropdown menus.
    I'm trying to design a chart which shows figures per city.
    In the first dropdown menu you can choose a city.

    The other two dropdown menus will determine the date range of the chart.

    I did not manage to figure out how to create this chart and I hope there is someone here smart enough he or she can!

    I'm looking forward to your response.

    I will post a dummy file to explain further.
    Attached Files Attached Files

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: Dynamic chart based on three dropdown menus.

    Hi,

    Welcome to the Forum.

    I have created a dynamic chart in the attached file with 3 drop downs. Please see if this suits your requirement.


    Regards,
    Chandra


    Please click on ‘* Add Reputation’ if this was helpful
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-25-2014
    Location
    Delft
    MS-Off Ver
    2007
    Posts
    2

    Re: Dynamic chart based on three dropdown menus.

    Dear Chandra,

    Thank you for your reply and effort!
    It is almost what I had in mind.

    I have a new file in which someone else succeeded.
    It is in the attachement for those who have the same problem.
    First I have to try to understand because it is still very difficult. :P

    Kind regards,

    Boudewijn Groot
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamic chart with 2 dropdown boxes
    By budadek in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2013, 06:15 AM
  2. How to pull data based on 2 different dropdown menus
    By ddodge68 in forum Excel General
    Replies: 5
    Last Post: 07-11-2012, 01:22 PM
  3. Dynamic dropdown menus
    By skankingpigeon in forum Excel General
    Replies: 2
    Last Post: 04-18-2012, 07:55 AM
  4. Multi ComboBoxes for Dynamic Dropdown Menus
    By Donal28 in forum Excel General
    Replies: 5
    Last Post: 08-30-2010, 11:07 AM
  5. Dynamic Chart DropDown
    By noel414 in forum Excel General
    Replies: 2
    Last Post: 11-05-2008, 09:48 PM

Tags for this Thread

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