Chart Data

[jtodd]

Hi
I have a sheet with 20 graphs that gets its data from another sheet ,
Is there a way of changing the source sheet ie

I have up to 10 sets of data on separate worksheets all with the same data just from different depts .

What I would like is one set of graphs but be able to choose which dept to view.
In other words be able to change the source of all the graphs in one go , perhaps from a dropdown ?

Hope this makes sence !!

 

[VBA Geek]

it is possible but without seeing the file I can't say much. You could build pivot tables and filter them with slicers and link the chart to the pivot table