How to create a dynamic graph with check boxes to choose a specific year?

Hello everybody,

I am trying to create a diagram which shows me data for certain years. The years should be selectable via checkboxes. Only the selected years should be displayed in the diagram.
The data is to be displayed in the form of a stacked bar chart.
In the attachment is my previous Excel file, into which the checkboxes are already linked to the corresponding cells (True=Wahr; False=Falsch).
Is there a simple way to link the data in the table to the diagram so that it is possible to sepereate the Information into years?

Thanks in advance.

Best regards
gauger

Hey ben,

thank you so far for your help.

unfortunately I need another layout of the diagram. For example, if I select 2 years, they should not be cumulated in a column, but displayed next to each other in the diagram. For example, if I select 2018 and 2019, a total of 24 months will be displayed on the x-axis. Each month of a particular year should therefore represent a separate column in the diagram. A changing x-axis, so to speak.

Do you have any idea how I can solve this Problem?

Best regards
gauger

Hey JeteMC,

thank you so much for your help, this was exactly what i was searching for.

Best regards
Gauger

Hey again,

I actually have one more question. Is it possible if the values in sheet2 Change, that automatically the graph changes? if I enter other values in sheet2 at the moment, the bars in sheet3 are not adjusting.

Thank you in advance.

Best regards
gauger

After making any changes, go to Data tab--->Select RefreshAll. The change will affected in Graph.

Thank you guys for your help. I am fine with this solution :P

BR
gauger