How to Make a Pie Chart in Excel with Words (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

This tutorial will demonstrate the steps to make a pie chart in Excel with words. Pie charts are very useful when you need to transform data into a pie chart for better representation. Every section of a pie chart presents its data and the whole pie chart shows the whole data at a glance. A pie chart performs best when you have data with one series. After going through this article, you can make a pie chart in Excel yourself.


Watch Video – Make a Pie Chart in Excel with Words


Step-by-Step Procedures to Make a Pie Chart in Excel with Words

We’ll use a sample dataset overview as an example in Excel to understand easily. If you follow the steps correctly then you should make a pie chart in Excel on your own. We will illustrate the steps throughout this article.

Step 1: Arranging Dataset for Making Pie Chart in Excel

For instance, we have a dataset of people with their  Names in Column B and  Work Hours in Column C. At this point, you want to make a pie chart.

Arranging Dataset for Making Pie Chart in Excel


Step 2: Making Excel Pie Chart with Words

Our main goal is to make a pie chart to present the series of data at a glance.

  • First, select the data and click on the Insert tab.
  • Then, go to the Insert Pie or Doughnut Chart option and select 2-D Pie.

Making Excel Pie Chart With Words

  • After selecting the pie as your need, you will find the result like the below image.

Making Excel Pie Chart With Words


Step 3: Labeling Chart Data

In this case, we aim to label the pie chart with proper data to present it perfect data series. To do that we have to follow the following steps:

  • Select the graph chart and go to the Chart Elements option.
  • Next, click on the Data Labels option to label the pie chart.

Labeling Chart Data

  • After that, this image will come on your screen.

Read More: How to Make Pie Chart in Excel with Subcategories


Format Excel Pie Chart

Now, we want to Format the Pie chart in Excel to make it more visually attractive. We can do that by performing the below ways:

Using Different Styles and Colors

Initially, we want to present the data labels more suitably. For that, we will do as described below:

Steps:

  • Select the chart and press the Chart Elements option.
  • Use the Data Labels option to go to the Data Callout option.

Format Excel Pie Chart

  • After that, you will the following result.

Format Excel Pie Chart

Next, our target is to change the text Legend. To do that, we will follow the instructions given below:

  • Select the chart and press the Chart Design tab.
  • Afterward, go to Add Chart Element option and use Legend to make the changes accordingly.

Format Excel Pie Chart

Moreover, if we want to present the whole pie chart differently, we can change it by this process:

  • Select the whole chart and go to the Chart Design tab.
  • Choose the pie chart as your wish.

Format Excel Pie Chart

  • After clicking on the selected pie chart the following image will come on your screen:

Format Excel Pie Chart

Read More: How to Create a Pie Chart in Excel from Pivot Table


Adding a Pie of Pie or Bar of Pie Chart

In this case, our goal is to present the pie with a more individual description of o certain section. To do that we will perform the following procedures:

Steps:

  • Select the whole data table and go to the Insert tab.
  • Go to the Data Callout option and select the Pie of Pie option.

  • After that, you will find the proper result below.

  • If you want to use a bar of a pie chart, then do the process similar to Pie of Pie Chart but with a slight change in the last portion. In the last step, select the Bar of Pie Chart instead of the Pie of Pie Chart option.
  • Finally, you will find this result.

Read More: How to Make a Pie Chart in Excel with One Column of Data


Things to Remember

  • We have shown the steps of making a pie chart in 2-D Pie. But it is recommended to never use the 3-D Pie option because it’s simply of no use. In many cases, it creates confusion by carrying the wrong message.
  • The pie chart works best in the case of only one data series. If you use more than one series, it can create complications.

Download Practice Workbook


Conclusion

Henceforth, follow the above-described methods. Thus, you will be able to make a pie chart in Excel with words. Let us know if you have more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles


<< Go Back To Make a Pie Chart in Excel | Excel Pie ChartExcel ChartsLearn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Zehad Rian Jim
Zehad Rian Jim

Zehad Rian Jim is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He's good with Microsoft Office and has written more than 80 helpful articles for ExcelDemy in the last year. Now, he makes fun and easy-to-follow Excel tutorials for YouTube as part of the ExcelDemy Video project. Zehad loves figuring out Excel problems, and his passion for learning new things in Excel shines through in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo