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/
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/