Microsoft PowerPivot for Excel 2010 – Adding Pivot Chart

I discussed how to add a Pivot Table in my previous blog, and now I am going to show you how to add its twin brother, Pivot Chart.

• Start on the worksheet that contains your Sales by Channel PivotTable.
• On the PowerPivot tab in Excel, click PowerPivot Window.
• On the PowerPivot Home ribbon, click the arrow below PivotTable and select PivotChart.

• Select Existing Worksheet and click OK.

• Select the empty PivotChart.

• In the FactSales table, select the TotalSales field.
• In the DimChannel table, select the ChannelName field.
• In the DimDate table, select CalendarQuarter.  Move SumofCalendarQuarter to the Legend Fields box.

• The following PivotChart would be generated.

• Right-click on the numbers and select Format Axis. Click Axis Options and in the Display units dropdown, select Millions and then click Close.

If you were able to create the Profit by Category Pivot Table that I suggested in my previous blog, then try to build a similar Profit by Category  Pivot Chart.  Have fun!

 

• Microsoft PowerPivot for Excel 2010 – Data Analysis Expressions (DAX)
• Microsoft PowerPivot for Excel 2010 – Adding Slicer
• Microsoft PowerPivot for Excel 2010 – Adding Pivot Chart
• Microsoft PowerPivot for Excel 2010 – Adding Pivot Table
• Microsoft PowerPivot for Excel 2010 – Creating Relationships Among Data
• Microsoft PowerPivot for Excel 2010 – Importing Data
• Why Microsoft PowerPivot?
• Microsoft PowerPivot for Excel 2010 – Introduction
• Excel 2010 – PowerPivot

Andrew Chan is the owner and founder of ALG Inc.

We help you to make better and faster decisions!