If I need to repeat the same chart multiple times for different regions or say different sub-organizations or any other dimension... is copy pasting the chart multiple times the only option or is there any other trick to just get excel to repeat it based on a chosen dimension.
Ideally would love to have it dynamic so say for a certain year one of the dimensions has no data then the chart will not be shown. Kind of like a pivot table but for Charts.
Note: I do want to show the chart multiple times so slicers or pivot chart filters are not an option.

Ideally would love to have it dynamic so say for a certain year one of the dimensions has no data then the chart will not be shown. Kind of like a pivot table but for Charts.
Note: I do want to show the chart multiple times so slicers or pivot chart filters are not an option.