How to Customize Excel Pie Charts with Custom Text & Data Labels

Mr. Devotor

In this quick and easy Microsoft Excel tutorial, you will learn exactly how to add text, data labels, and percentages to a pie chart. If you have a chart—like the monthly sales breakdown shown in the video—adding clear text labels directly onto the slices makes your data much easier to read at a glance!  We break down two simple methods: how to use the quick-access Chart Elements button to toggle data labels on, and how to format those labels to show category names or percentage breakdowns. We also cover how to insert a custom, free-floating text box for notes or disclaimers that stays locked to your chart. Perfect for beginners looking to improve their data visualization skills in Excel! #ExcelTutorial #ExcelTips #DataVisualization #MicrosoftExcel #OfficeSkills #mrdevotor

Transcript

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

00:06adding

00:06text or labels to a pie chart in excel is a great way to make the data much easier to

00:13read at a

00:13gallons so you can add the actual data values percentages or the customs category names

00:19directly onto the slices so in the first method we need to click on your pie chart to select it

00:25and then go to the top of your screen and click on the chart design and on the left side

00:34of the ribbon

00:35click the add chart element and now over your data labels and choose where you want the text to set

00:45for example if you want to add the chart title you need to click on that and click on the

00:51above chart

00:52or the centrally overlay chart so click on the above chart and now click inside the box and type the

01:01desired text so you can also select it and go to the home and change the color of your choice

01:11like this

01:12one whatever you color like it so moreover if you want to add a unique piece of text that is

01:22not

01:23tied to the suppression data like a small note or a disclaimer inside the chart area for this you need

01:29to select the chart and then go to the insert tab on the top ribbon and click the text

01:39text box here is the text you need to click on that and click on the text box and drag

01:45your mouse to draw

01:46a text box then type your custom text for example sales target so you can reposition this text box to

02:00you can move anywhere in the pie chart like this one you can resize it from the these corners even

02:08you can

02:10rotate it like this one

02:16you can move it to anywhere in the pie chart

02:23moreover if you want to remove the borderline for this you need to click on the shape format

02:31and click on the shape outline and click on the no outline and click outside here you can see that

02:39the border has been removed and when you click on that you can select it and can change the color

02:47of your

02:47choice

02:54like this one

02:56so this way you can easily add text in the pie chart in excel if you think this video is

03:01helpful please

03:02support my channel thanks for watching

Category

Transcript

Comments

Recommended