Dynamic Buttons for Choosing Areas to display in Diagram

[Bim1]

I have a file that displays services in certain business areas and groups. The areas and groups can be chosen in a dropdown menu. The services that are displayed then shall be shown in a diagram. Since there are too many services to properly see something in the diagram, we need to be able to choose just 1-5 services that shall be displayed. Is there a way to include a checkbox or the like to choose the services that shall then be displayed in the diagram? This, of course, also needs to be adapting to the areas and groups chosen (the amount of services in there differs). Does someone have a hint on how to best do this?

cheers

Book1.xlsx

[Andy Pope]

Why not turn you data in to a table and then you can use the built in filtering options for tables.

With the chart using the table the legend will automatically update itself.

[Bim1]

because the filter won't be useful for the amount of services that are in one group. plus, we would like it to look nice and be easy to handle. so we ruled out the usual filter options for the tables. it is just not handy in this case.

[Andy Pope]

You could use a activex listbox to allow multi-select but you would need could to determine choices and apply them.

A better way would be to create a userform to gather user choices and then update everything.