Q. I want to set up some monthly dashboard reports where I have a template of multiple graphs and tables on one page. Can this be done with Pivot Tables?
A. There are several options to set up Dashboards in Excel. The best source for dashboard layouts will be found in Templates.
In Excel 2007, choose Templates from Office Online and type Dashboard as your search Criteria. In Excel 2010, the Search Box will appear on the Backstage view when you click File and New.