In this video, Michele shows you how to build a PivotChart using PowerPivot data. Once you've imported data into your PowerPivot workbook, PivotCharts help you efficiently summarize, analyze, explore, and present your data.

PivotCharts provide an interactive graphical representation of the data in your PivotTables and help you see comparisons, patterns, and trends. Changes you make to the layout and data in the associated PivotTable are immediately reflected in the layout and data in the PivotChart.

Tutorial video by Michele Hart, Microsoft SQL Server Technical Writer.

Add a PivotChart to Your Analysis

  1. Start on the worksheet that contains your Sales by Channel PivotTable.

  2. On the PowerPivot tab in Excel, click PowerPivot Window.

  3. On the PowerPivot Home ribbon, click the arrow below PivotTable and select PivotChart.

    Be sure to create the PivotChart from the PowerPivot ribbon. There is also a PivotChart button on the Excel ribbon but Excel PivotCharts cannot access your PowerPivot data.

  4. Select Existing Worksheet and click OK.

    Excel adds an empty PivotChart to the same worksheet that contains your Sales by Channel PivotTable.

  5. Select the empty PivotChart.

    If you get an error message telling you the data list is no longer valid, right-click the chart and select Refresh Data.

  6. In the dbo_FactSales table, select the TotalSales field.

  7. In the dbo_DimChannel table, select the ChannelName field.

  8. In the dbo_DimDate table, select CalendarQuarter.

  9. This layout isn’t meaningful. In the bottom half of the PowerPivot Field List, move SumofCalendarQuarter to the Legend Fields box. Now you can see the trend of sales by quarter.

    The PivotChart and PivotTable now display the same data – in very different layouts.

  10. The axis numbers are truncated so right

View all the PowerPivot videos on YouTube in the official SQL Server PowerPivot playlist.


See Also


External Links