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.

image

  • Select Existing Worksheet and click OK.

image

  • Select the empty PivotChart.

image

  • 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.

image

  • The following PivotChart would be generated.

image

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

image

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!

image

 

Andrew Chan is the owner and founder of ALG Inc.

We help you to make better and faster decisions!

About Andrew Chan
Andrew Chan is an Business Consultant who gives you accurate, consistent and timely information so that you can make better and faster decisions. He is an Associate of Society of Actuaries with over 20 years of IT experience. Apart from strong analytical skills and proven technical background, he was also a former system director at Manulife who had extensive project management experience. If you are looking for someone to gather, consolidate, validate, visualize and analyze data, look no further! Andrew can provide the most cost effective business analytics solution so that you can explore, optimize, predict and visualize your business. Don’t guess on any decision, no matter it is finance, operation, marketing or sales! Always ask for evidence!

9 Responses to Microsoft PowerPivot for Excel 2010 – Adding Pivot Chart

  1. Pingback: Microsoft PowerPivot for Excel 2010 – Adding Slicer | Technologies and your business

  2. Pingback: Microsoft PowerPivot for Excel 2010 – Adding Pivot Table | Technologies and your business

  3. Pingback: Microsoft PowerPivot for Excel 2010 – Creating Relationships Among Data | Technologies and your business

  4. Pingback: Microsoft PowerPivot for Excel 2010 – Importing Data | Technologies and your business

  5. Pingback: Why Microsoft PowerPivot? | Technologies and your business

  6. Pingback: Microsoft PowerPivot for Excel 2010 – Introduction | Technologies and your business

  7. Pingback: Excel 2010 – PowerPivot | Technologies and your business

  8. Pingback: Microsoft PowerPivot for Excel 2010 – Data Analysis Expressions (DAX) | Technologies and your business

  9. Pingback: Wish you a Merry Christmas and a Happy Analytics Year! « Technologies and your business

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: