Hi all,
I have 2 excel worksheets with various data. The first worksheet contains stats for X, Y and Z, whilst the second worksheet is a number of pivot charts. At the moment, the pivot charts are linked with all the stats from the first worksheet. This is fine, however I want a way in which you can specifically select which stats to show in the pivot charts (i.e. only show X, show both Y and Z etc.) without having to create a separate worksheet with the same charts. So my question is how do I create a some sort of drop down cell where I can change what data is represented in the pivot charts?
I hope this makes sense and many thanks in advance.
Bookmarks