✦Template Printable Ideas Insights

"Master Microsoft 365: Step-by-Step Guide to Create Pie Charts"

By

Creating a pie chart in Microsoft 365 is a straightforward process that can help you visualize your data effectively. This step-by-step guide will walk you through the process, ensuring you create engaging and informative charts to communicate your data's story.

Microsoft 365's Excel is our primary tool for creating pie charts, as it offers a user-friendly interface and powerful data analysis features. Let's dive right in and explore how to create your first pie chart.

Preparing Your Data

Before you begin, ensure your data is clean and organized in an Excel worksheet. For a pie chart, you'll need your data categorized into distinct groups. For example, if you're creating a pie chart to display market shares, your data might look like this:

STUNNING #3D #PIE #Chart Tutorial in Microsoft Office 365 PowerPoint PPT
STUNNING #3D #PIE #Chart Tutorial in Microsoft Office 365 PowerPoint PPT
MS Excel 2016: How to Create a Pie Chart
MS Excel 2016: How to Create a Pie Chart
Creating Pie of Pie and Bar of Pie charts
Creating Pie of Pie and Bar of Pie charts
CompanyMarket Share
Apple40%
Samsung32%
Huawei12%
Other16%

Now, let's create your pie chart using these data categories.

Inserting the Pie Chart

After organizing your data, select the range of cells containing your categorical data and corresponding values. Now, click the Insert tab in the ribbon, then locate the Charts group. Click on the first icon (Pie) and select your desired chart variant.

How to Make a PIE Chart in Excel (Easy Step-by-Step Guide)
How to Make a PIE Chart in Excel (Easy Step-by-Step Guide)
How to create a Pie chart in PowerPoint
How to create a Pie chart in PowerPoint
How to Create a Pie Chart in Google Sheets: A Simple Step-by-Step Guide (With Example)"
How to Create a Pie Chart in Google Sheets: A Simple Step-by-Step Guide (With Example)"

Excel will automatically create a pie chart using your selected data. If your data isn't grouped properly, Excel will display an error. Make sure your data is structured with categories in one column and their corresponding values in another.

Customizing Your Pie Chart

Let's make your pie chart more engaging by adding a title and adjusting your data labels.

To add a title, click the Layout tab under Chart Tools in the ribbon. In the Labels group, click Chart Title, enter your desired title, and click Close.

Free Custom Pie Chart Tool
Free Custom Pie Chart Tool
How to Make a Pie Chart in Microsoft Word | Techwalla
How to Make a Pie Chart in Microsoft Word | Techwalla
Convert Table to Pie Chart in MS Word | How to Make a Chart in MS Word | MS Word 2010/2019/2025
Convert Table to Pie Chart in MS Word | How to Make a Chart in MS Word | MS Word 2010/2019/2025
How to Create a Sliced Donut Chart in Excel | Easy Step-by-Step Guide
How to Create a Sliced Donut Chart in Excel | Easy Step-by-Step Guide
Excel Pie Chart - Introduction to How to Make a Pie Chart in Excel
Excel Pie Chart - Introduction to How to Make a Pie Chart in Excel
How to Create a Pie Chart in Microsoft Excel
How to Create a Pie Chart in Microsoft Excel

To adjust data labels, right-click on any sector of the pie chart and select Add Data Labels. This will display the value for each category. If you'd like to add category names as well, right-click on the chart again and select Select Data. In the pop-up window, under Legend Entries (Series), click .edit, and check Show Series Name as Label.

Exploring Pie Chart Variations

Excel offers several pie chart variations to best represent your data. Let's explore two popular alternatives: 100% stacked pie charts and exploded pie charts.

100% Stacked Pie Chart

A 100% stacked pie chart can help you compare the proportions of categorical data. To create one, select your pie chart, then click Switch Row/Column in the Design tab under Chart Tools in the ribbon. This will stack your categories and make it easy to compare their proportions.

How to Create a Pie Chart in Microsoft Excel
How to Create a Pie Chart in Microsoft Excel
How to Count Items and Make Pie Charts in Microsoft Excel
How to Count Items and Make Pie Charts in Microsoft Excel
How to Create a Basic Pie Chart in Microsoft Excel 2007
How to Create a Basic Pie Chart in Microsoft Excel 2007

To add value labels, right-click on the chart and select Add Data Labels. This will display the percentage contribution of each category to the whole.

Exploded Pie Chart

An exploded pie chart can emphasize a specific category or slice by separating it from the rest of the chart. To create one, select your pie chart, then click Explode in the Format tab under Chart Tools in the ribbon. Click and drag the exploding slice to adjust its distance from the chart.

To add emphasis, you can also change the color of the exploded slice. To do this, right-click on the slice, select Format Selection, and adjust the Fill color in the pop-up window.

Creating an engaging and informative pie chart requires a balance of data-driven insights and aesthetic appeal. By following this guide, you'll be well on your way to creating captivating pie charts in Microsoft 365 that effectively communicate your data's story.