✦Template Printable Ideas Insights

Step-by-Step Guide: Create Pie Charts in Office 365

By

Creating visually appealing charts, such as pie charts, can greatly enhance your presentations and reports. Microsoft Office 365 simplifies this process with its intuitive chart creation tools. Here's a step-by-step guide on how to create a pie chart in Office 365, using Microsoft Excel as an example.

Before we dive in, ensure you have data ready in an Excel worksheet. In this guide, we'll use data from a simple sales report: 'Category', 'Sales', and 'Region'. Let's get started!

Preparing Your Data

Before creating a pie chart, ensure your data is properly formatted. In our case, 'Sales' data should be numerical, and other columns should contain relevant text or category information.

STUNNING #3D #PIE #Chart Tutorial in Microsoft Office 365 PowerPoint PPT
STUNNING #3D #PIE #Chart Tutorial in Microsoft Office 365 PowerPoint PPT
How to create a Pie chart in PowerPoint
How to create a Pie chart in PowerPoint
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)

For this example, we'll create a pie chart based on 'Category' and 'Sales'. So, make sure 'Category' is in Row 1, starting from Column A, and 'Sales' data is beside it. Here's a quick check:

Data Organization Tips

Ensure your data is clean and easy to read. Remove any blank or unnecessary rows and columns. If your data spans multiple worksheets, consider consolidating it into one for better visibility.

MS Excel 2016: How to Create a Pie Chart
MS Excel 2016: How to Create a Pie Chart
How to make a pie chart in Canva
How to make a pie chart in Canva
Free Custom Pie Chart Tool
Free Custom Pie Chart Tool

For our pie chart, we don't need 'Region' data, so we'll hide it for now. You can still use it later when customizing your chart.

Creating the Pie Chart

Now that your data is ready, it's time to create the pie chart. Here's how:

1. Select the data you want to include in the chart. In our case, select the range A1:B6.

How to Create a Pie Chart in Excel (Free Template)
How to Create a Pie Chart in Excel (Free Template)
Creating a 3D Pie Chart in Excel Vid.wmv
Creating a 3D Pie Chart in Excel Vid.wmv
How To Create A Pie Chart In Excel (With Percentages)
How To Create A Pie Chart In Excel (With Percentages)
how to make pie chart in excel with percentages
how to make pie chart in excel with percentages
Reporting Tools: Creating Pie Chart in Report [Shot on v2019]
Reporting Tools: Creating Pie Chart in Report [Shot on v2019]
Learn how to create attractive Pie Charts in Excel
Learn how to create attractive Pie Charts in Excel

2. Go to the 'Insert' tab and click on 'Pie' in the 'Charts' group. Choose the first pie chart style. Excel will automatically create a pie chart based on your selection.

3. Excel places your new chart on a separate chart sheet. To move it back to your data, click and drag the chart until it hovers over your data, then drop it there.

Customizing Your Pie Chart

With your pie chart in place, let's make it look more engaging and informative. We'll change the chart title, color scheme, and labels.

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
Pie Chart In Excel 15 New Thoughts About Pie Chart In Excel That Will Turn Your World Ups...
Pie Chart In Excel 15 New Thoughts About Pie Chart In Excel That Will Turn Your World Ups...
How-to Create a Dynamic Excel Pie Chart
How-to Create a Dynamic Excel Pie Chart

Adding a Chart Title

A clear title can help your audience understand the chart's purpose. Here's how to add one:

1. Click anywhere on the chart to select it. Go to the 'Design' tab (under 'Chart Tools').

2. In the 'Type' group, click on 'Add Chart Element' and then 'Chart Title'.

3. Type 'Sales Category Comparison' in the new text box and format it as desired.

Changing the Color Scheme

A compelling color scheme can help differentiate categories and catch the eye. Here's how to switch it:

1. Right-click on any slice of the pie chart, then click 'Format Selection' or 'Format Data Labels' (in the pop-up menu).

2. In the 'Format Selection' pane, go to the 'Fill' section. Click the color box (under 'Solid fill') to choose a new color. Repeat this for each category.

Modifying Chart Labels

By default, Excel adds data labels (sales amounts) to each slice. Let's change these to show category names instead:

1. Right-click anywhere on the chart and select 'Add Data Labels' from the context menu.

2. Hover over a data label. A red border appears, and a blue dot turns on. Click the blue dot, then select 'Category Name' from the list that appears.

Excel replaces the sales amounts with category names, making the chart more meaningful.

Creating a pie chart in Office 365 isn't just about the final product – it's about understanding your data and communicating it effectively. Now that you know how to create and customize pie charts, you're equipped to deliver more engaging reports and presentations. Happy charting!