HELP WITH CHART

[Anonymous]

Hi everyone,

I have Industry Variable, which consist of different indusryes.

I have Client Variable, which consist of different clients and are part of the Industry.

I have a button, which I select minimum data in each month. I want to remove clients that do not match the condition.

I want to create a chart, which show TOTAL (all clients together), Industry (only clients in this Industry) and Client.

Please suggest any ideas how to do that.

Please see my attached file.

[Anonymous]

Maybe use macro for it?