• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple dropdowns and Interactive charts

ajoshi76

Member
I need to create cascading dropdowns using indirect function. and then based on these dropdowns charts should appear.

If drop downs are all, then all charts (miniature) should appear
If one dropdown is selected and rest are all then all charts related to that dropdown selection should appear
if 2 dropwns are selected then all charts relating to the 2 dropdowns should appear
if all 3 dropdowns are selected then one chart should appear

Dropdown 1 = Business Group
Dropdown 2 = Category
Dropdown 3 = Chart name

Can someone help using the concept Chandoo posted. Link Below

http://chandoo.org/wp/2013/04/23/interactive-chart-in-excel-tutorial/
 
Hi Joshi ,

It would help if you could do the groundwork and upload a sample so that only the interactivity needs to be incorporated ; just put in some reasonable amount of data , insert the chart with a couple of series , and upload your workbook.

Narayan
 
Back
Top