Visualizing data with PivotCharts

Usually, when people think of a dashboard, they think of something that is visually interesting and can tell a story. PivotCharts are a great tool to accomplish this in Excel.

Let's create a dashboard for Tadeas so he can understand more about the sales performance. We can create some cohesive visualizations to tell the story of the company overtime and performance between the two sales offices.

Continue working in your current workbook. If you've lost process, open 4_2_kpi_analysis.xlsx from the Workbooks folder in the course materials.