How to add percentage in pie chart in excel

Mr. Devotor

In this quick and easy Microsoft Excel tutorial, you will learn exactly how to add percentages to a pie chart. If you have a data table showing monthly breakdowns—like the January to June spreadsheet shown in this video—converting those raw numbers into clear percentage data labels makes your chart look incredibly professional and easy to understand at a glance!  We break down the entire process step-by-step: how to select your pie chart, how to turn on data labels using the quick-access chart elements button, and how to format those labels to display actual percentage values instead of regular numbers. This is a must-know Excel trick for students, business professionals, and anyone looking to master chart design! #ExcelTutorial #ExcelTips #MicrosoftExcel #PieChart #DataVisualization

Transcript

00:00hi everyone in this video i will guide you how to add percentage in pie chart in excel make sure

00:07adding percentage to a pie chart in excel converts your raw numbers into easy to read proportionals

00:15instantly so in the first method you need to select your chart by clicking inside your pie

00:23chart and now click the green plus icon that appears at the top right corner of the chart

00:32border and then hover your data labels and check the box next to it and now click the small arrow

00:40next to the data labels and select the more options at the bottom of the flyout menu now the format

00:50data

00:51label screen will open up on the right side of your excel window so under the label options tab you

00:57need to check the box for the percentage and here you can see that percentage is appeared if you want

01:06to uncheck the value then the value will be removed and only percentage will be appear if you want to

01:14add category along that you just need to click on that and the month is also included with the

01:20percentage so if you want to position the label you can make it center you can inside edge you can

01:30outside end and click the best fit for the pie chart moreover excel has pre-made visual layout that

01:39automatically calculate and display percentage with a single click for this you need to select the pie chart

01:48and then look at the top ribbon menu and click on the chart design tab and on the far left

01:56side click the quick

01:58layout

02:01and now over the options and choose the layout that shows percentage signs like this one

02:11moreover there is another right click the slice method for this you need to select the pie chart and then

02:19again click to select the particular slice and now right click directly on any of the colored slide in

02:27your pie chart which you have selected it and now click on the add data labels and click on this

02:35arrow

02:36and click on the add data callout and this particular size percentage has been appeared and if you select all

02:47the

02:47slices right click go to the add data label click on this arrow and click on this add data callouts

02:56and here you can see that

02:59so this is pretty simple and easy i hope you understand how you can add percentage in pie chart in

03:03excel

03:04if you think this video is helpful please support my channel thanks for watching

Category

Transcript

Comments

Recommended