Dynamic Chart - How do I show Product Grouping based on Industry?

[bpower]

hello excel ninjas!
I refer to "Dynamic" tab for my end report. the current pivot table is dynamic, filtered based on industry. I'm wondering if I can add one more drop-down list or check box and show the graphs based on that second tier filter?
thanks for sharing your thoughts!

 

[Hui]

BPower

Firstly, Welcome to the Chandoo.org Forums

Shift/Drag the Industry Field from the Filters area to be in the Rows area
You can add/remove subtotals if you want

 

[Hui]

If you upgrade the file to be Excel not Excel 2003 you will also be able to add slicers to the model, these allow you to interactively click on buttons to select/deselect field values
Refer: https://chandoo.org/wp/2015/06/24/introduction-to-slicers/

 

[bpower]

Much appreciated Hui! However, my chart doesn't take the data from the pivot table thus even if I add more filter in pivot table, my chart won't change automatically. I would presume that I need to modify my formula for the chart.

 

[Hui]

Have a look at the chart and control on the Chart worksheet

 

[bpower]

Thanks Hui! what I understand from your solution is that we would have 2 drop down list.
the first one is from the pivot table and the other one for the chart, so the user of the report will have to select 2 boxes. I am wondering if the chart and the table can be linked to only 1 drop down list, but I guess in that case I need to re-setup my table on the "Chart" tab?

 

[Hui]

No

Just, Link the chart to the Pivot Table

see attached

 

[bpower]

but by doing that I won't be able to show chart for the product, because pivot table list only contains Industry not Product. Please correct me if I'm wrong.