how to show percentage in pie chart excel

"Mastering Excel: Displaying Percentage in Pie Charts"

By Jessica Moore
AD

Ever found yourself wanting to present data in a clear, engaging way but struggled with the best visual representation? A pie chart, with its slices perfectly illustrating proportions, can be an excellent tool. But you might be wondering, "How do I show percentage in a pie chart in Excel?" This article walks you through the process step by step.

Before we dive in, ensure that your data is in Excel, and you understand what each data point represents. This makes it easier to represent your data accurately in a pie chart.

Preparing Your Data in Excel

First, let's get your data ready. You might have a list of sales figures for different regions, for instance. Your data could look like this:

AD
Show Percentages in Excel Pie Chart
Show Percentages in Excel Pie Chart
How to Show Percentage and Value in Excel Pie Chart - ExcelDemy
How to Show Percentage and Value in Excel Pie Chart - ExcelDemy
How to Make a Pie Chart in Excel: 5 Suitable Methods - ExcelDemy
How to Make a Pie Chart in Excel: 5 Suitable Methods - ExcelDemy
Region Sales (in $)
North 10000
South 12000
East 8000
West 15000

You can use the SUMIF or SUMPRODUCT functions to find the total sales if that's not already calculated.

Converting Values to Percentages

Now, we need to convert these sales figures to percentages of the total. In a new column, enter this formula: `=(cell_value/total_sales)*100`. Replace `cell_value` with the appropriate cell reference, and `total_sales` with the total sales figure. Then, drag the formula down to apply it to all sales figures.

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 Show Percentage and Value in Excel Pie Chart - ExcelDemy
How to Show Percentage and Value in Excel Pie Chart - ExcelDemy

Your data should now look something like this:

Region Sales ($) Percentage
North 10000 25%
South 12000 30%
East 8000 20%
West 15000 35%

Creating the Pie Chart

Now it's time to create your pie chart. Select the "Region" and "Percentage" columns, then click on "Insert" in the Excel toolbar and select the pie chart icon. Excel will create a default pie chart based on your data.

AD

Excel will automatically format your data points as percentages, but if you want to ensure this, right-click on the chart and select "Format Selection". Under the "Data Labels" section, set "Format Data Labels". Then, under "Number", set "Category" as "Percentage". Click "Close", and your pie chart should now display percentages.

Formatting and Editing Your Pie Chart

To make your pie chart engaging and informative, you'll likely want to make some adjustments. Here are a few tips:

Customizing Slice Colors

To give each slice a specific color, right-click on your chart, select "Format Selection", then under "Fill", choose the solid fill color you want.

AD

If you want each slice to correspond to a specific color, you can change the "Region" column to use colored cells. Then, in your pie chart, click on the respective slices and change their fill colors to match your data.

Adding a Title and Labels

To add a title, right-click on your chart and select "Add Chart Element", then choose "Chart Title". For labels, select "Add Chart Element" and choose "Data Labels". You can change the font, color, and other attributes of these elements under the "Chart Styles" tool on the "Design" tab.

There you have it! Now you know how to show percentage in a pie chart in Excel. Play around with your chart's appearance to make it informative and engaging. Happy data visualizing!

AD
AD