Chart change- using drop downs

[bilboy]

Hi All,

Is it possible to change chart based on multiple drop down selection

Example in this case

PRODUCT= A

Class= X

Variant= L

and the chart will populate with the respective value, and if we select other combinations.

Is it possible that the chart will change accordingly.


File attached for reference.

 

[Asheesh]

Hi Bill - here you go

 

[Hui]

I would suggest that you fill out the table
Then add an area to extract the data
I used Sumproduct but you could have used Index/Match combo

See attached

 

[bilboy]

Thanks Asheesh, and Hui, Thanks a lot.. cheers!!!