Create Multiple drop down for Charts

[Chandrashekar R]

Am working in one of Trade operation team, the team head count is 58 staffs, i need to create chart for Defect Trend and Productivity Trend chart to individual.

In Excel

Combo Box - replicate Staff name.

1. Radio Button - Productivity Tab should replicate productivity chats
2. Radio Button - Defect Tab should be replicate Defect Charts

when i select productivity tab in should be replicate the data as per combo box staff name and similar for defect tab.

I want to create similar chart like Interactive chart

Thanks

regards
RCS

 

[Luke M]

Hi RCS,
I'm afraid we don't have much information to go on. You talk about differetn charts, but I'm not sure what type of chart, or what your data layout looks like. Your uploaded workbook is a good example, but it's a standard one from Chandoo. Do you need help understanding how it works, or can you input your data into the template?