Using Multiple Charts and Tables
When creating pivot tables and charts to display and make sense of the data, you often want to create a dashboard that
easily allows you to determine performance. You may be interested in sales performance, network performance, or
assembly-line performance. Dashboards combine visual representations, such as key performance indicators (KPIs),
graphs, and charts, into one holistic view of the process. Although they are not technically considered
tools, you can create some very compelling data displays using Excel with Power Pivot tables and charts that can then
be displayed and shared in SharePoint.
When adding multiple charts and tables to a dashboard, you may want to link them together so they represent the
same data in different ways. You also will probably want to control them with the same slicers so that they stay in sync.
The easiest way to do this is to add them using the Insert tab and selecting PivotChart & PivotTable (see Figure
Selecting a chart type