This results in a dynamic dashboard that allows recipients to look over your presented data while allowing them to sort through the data to give them customization options pertinent to them. You can then decide how the dashboard should appear, what will tell the best story for your report. With each resulting chart, you can choose to copy and paste it on your dashboard. Select PivotTables to link the Timeline to.Click on the items to use in the Timeline.Choose the PivotTables that connect to the chosen Slicer.From a PivotTable click on PivotTable Tools.Not only do they apply a filter, they also indicate the filter currently in use. Slicers are essentially click-to-filter options for PivotTables. Timelines allow you to filter by time to locate a specific period. Slicers and Timelines provide a way to filter through the data with ease. With your multiple PivotCharts and PivotTables created, you'll need to be able to find specific information that supports the details you wish to share in the dashboard. Click on Analyze under PivotChart Tools.Choose formatting options in the PivotChart Tools tab.How to generate PivotCharts from PivotTables Insert a name in the PivotTable Name box to identify the function of each table.Click on PivotTable Tools for each table.Select the original PivotTable that wish to use as your master or reference table.How to prepare your PivotTables for the Dashboard This reporting tool is highly adaptable and can be used to report a plethora of results regardless of your line of business. It provides a top-level view of the data, allowing your audience to quickly see data and trends in order to view results and make decisions. The Dashboard is your chance to showcase your data in an attractive, informative and insightful hub view. Once you have become comfortable enough to generate charts and tables using your provided data, it's time to begin piecing the story together in a dashboard. Once you have decided on the layout and contents of your PivotTable fields, you can use it as the foundation for other Pivot Tables. Click and drag fields to reside in either Filters, Columns, Rows, and Values.Click on fields to include in the report in the PivotTable Fields.Click Add this data to the Data Model to incorporate additional data sources in the PivotTable.Select New or Existing Worksheet under the Choose where you want the PivotTable to be placed section.Decide on the data source in the Choose the data that you want to analyze section, in case you don't want to use the selected source.Select PivotTable in the Tables section to generate the Create PivotTable dialog box.Click on the Insert tab in the navigation ribbon.Click on a cell within the source data or table range.Select criteria to aggregate duplicates by.Select to fill any missing points by zeros or by interpolation.Browse through the presented types of PivotTables.Navigate to the Tables section in the Insert ribbon tab.Select a cell within the table range or source data.