Filter charts on a dashboard to display charts that are on other worksheets in the same workbook [on hold]











up vote
1
down vote

favorite












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.










share|improve this question









New contributor




Rob Mulhern is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as unclear what you're asking by Máté Juhász, Toto, PeterH, Pimp Juice IT, Anaksunaman 18 hours ago


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.



















    up vote
    1
    down vote

    favorite












    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.










    share|improve this question









    New contributor




    Rob Mulhern is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.











    put on hold as unclear what you're asking by Máté Juhász, Toto, PeterH, Pimp Juice IT, Anaksunaman 18 hours ago


    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.

















      up vote
      1
      down vote

      favorite









      up vote
      1
      down vote

      favorite











      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.










      share|improve this question









      New contributor




      Rob Mulhern is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      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.







      microsoft-excel vba charts






      share|improve this question









      New contributor




      Rob Mulhern is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question









      New contributor




      Rob Mulhern is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question








      edited 2 days ago





















      New contributor




      Rob Mulhern is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 2 days ago









      Rob Mulhern

      62




      62




      New contributor




      Rob Mulhern is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Rob Mulhern is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Rob Mulhern is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.




      put on hold as unclear what you're asking by Máté Juhász, Toto, PeterH, Pimp Juice IT, Anaksunaman 18 hours ago


      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.






      put on hold as unclear what you're asking by Máté Juhász, Toto, PeterH, Pimp Juice IT, Anaksunaman 18 hours ago


      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.





























          active

          oldest

          votes






















          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes

          Popular posts from this blog

          Список кардиналов, возведённых папой римским Каликстом III

          Deduzione

          Mysql.sock missing - “Can't connect to local MySQL server through socket”