Pivot Tables  – the first step to creating a pie chart
Pivot tables help you summarize data in either a single column (typically) or multiple columns.

Select your data (both columns) and create a Pivot Table: On the Insert tab click on the PivotTable | Pivot Table (you can create it on the same worksheet or on a new sheet). Once you have your pivot table, you can INSERT just about any graphic – including Pie Charts – based on columns in that table. For aggregating the column data, right click on the column selector and pick ‘Sum of Values’.

Pivot Chart – To display more than one data series 

Errors

 

Pivot Table: The Command Requires At Least Two Rows Of Source Data 

Fix : Make sure you select the entire table (or sheet ) of data in excel. This should create a pivot chart with all the columns (you can pick and select the columns from this list later)

Anuj holds professional certifications in Google Cloud, AWS as well as certifications in Docker and App Performance Tools such as New Relic. He specializes in Cloud Security, Data Encryption and Container Technologies.

Initial Consultation

Anuj Varma – who has written posts on Anuj Varma, Hands-On Technology Architect, Clean Air Activist.

 Twitter Linkedin