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.

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

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