Bar Chart to Bar Chart.xlsx

I have a bar chart with level 1 data. I want to be able to click on any bar in that bar chart to create another chart that displays level 2 data for that level 1 item. For example, in the attached spreadsheet, on sheet Charts there is a chart with 3 bars: Air Foil, Root, and Tin Cap. I want to be able to click on the 'Air Foil' bar and have the spreadsheet automatically find the level 2 data for Air Foil and create another bar chart and put it on a separate sheet.