How to Filter charts on a dashboard to display charts that are on other worksheets in the same workbook?

So I know you can create the charts behind each other and move them forwards and backwards.

But for the template I want to create you will not always have data for all the different charts and some you may never use. So the filter would bring up nothing for some charts for a particular jobs dashboard.

So what I want is a master template with every possible chart and a main dashboard showing maybe 9 charts all of which can be filtered from the many individual chart worksheets.

closed as unclear what you're asking by Máté Juhász, Toto, PeterH, Pimp Juice IT, Anaksunaman Nov 15 '18 at 10:55

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.