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

For working or educational purposes, people use pie charts a lot. Pie charts help a user or viewer to understand statistical data easily. In this article, we will show you how to make a pie chart in Excel with one column of data.


Download Practice Workbook

You can download the free Excel workbook from here and practice on your own.


2 Handy Ways to Make a Pie Chart in Excel with One Column of Data

In Excel, pie charts help users analyze data. Sometimes, users need to make a pie chart from one column of data. In this article, you will see two easy ways to make a pie chart in Excel with one column of data. In the first approach, we will insert a PivotTable to make the pie chart, and in the second method, you will see the usage of Visual Basic Applications (VBA) to do the same. We will use the following data set for both the procedure.

 Handy Ways to Make a Pie Chart in Excel with One Column of Data

1. Inserting PivotTable to Make a Pie Chart in Excel

In this method, we will insert a PivotTable to make the pie chart in Excel with one column of data. The steps for this method are as follows.

Step 1:

  • First of all, highlight the entire column of your data.
  • For the following example, that is (B4:B14).

 Handy Ways to Make a Pie Chart in Excel with One Column of Data

Step 2:

  • Then, go to the Insert tab of the ribbon and choose PivotTable.

 Handy Ways to Make a Pie Chart in Excel with One Column of Data

Step 3:

  • After selecting, you will see that in the “Select a table or range” drop-down box the entire column of our data (B4:B14) is present.
  • Then, select “Existing Worksheet” and choose an empty cell near your data set.
  • For example, we will use cell D4 for this purpose.
  • After that, click OK.

 Handy Ways to Make a Pie Chart in Excel with One Column of Data

Step 4:

  • After clicking OK, a task pane named “PivotTable Fields” will appear.
  • From there, drag Sales in June 2022 to both Rows and Values at the bottom of the pane like the following picture.

 Handy Ways to Make a Pie Chart in Excel with One Column of Data

  • Finally, you will see a newly inserted PivotTable next to your data set.

 Handy Ways to Make a Pie Chart in Excel with One Column of Data

Step 5:

  • In the next step, after creating the PivotTable, select any cell from the table.

 Handy Ways to Make a Pie Chart in Excel with One Column of Data

Step 6:

  • Then, go to the Insert tab from the ribbon and click on “Insert Pie or Doughnut Chart” from the Charts.

 Handy Ways to Make a Pie Chart in Excel with One Column of Data

Step 7:

  • After that, you will see different pie models for the data sets. Select as per your choice.
  • For example, we will choose the Pie option under 2-D Pie.

 Handy Ways to Make a Pie Chart in Excel with One Column of Data

  • Finally, you will be able to make a pie chart with one column of data by following this method.

 Handy Ways to Make a Pie Chart in Excel with One Column of Data

Read More: How to Create a Pie Chart in Excel from Pivot Table (2 Quick Ways)


Similar Readings


2. Applying VBA to Make a Pie Chart in Excel

Apart from inserting PivotTable, you can also apply VBA Codes to make a pie chart in Excel with one column of data. This procedure requires coding to make the pie chart. You can follow the steps below to get familiar with this method.

Step 1:

  • First, we will use the following data set with one column for our working purpose.

 Handy Ways to Make a Pie Chart in Excel with One Column of Data

Step 2:

  • Then, to apply VBA, go to the Developer tab in the ribbon and choose Visual Basic.

Sample Data Set

Step 3:

  • After that, a new tab will open.
  • Then, from the Insert tab choose Module.

Sample Data Set

Step 4:

  • Fourthly, in the Module, paste the following VBA Codes.
Sub Make_a_Pie_chart()
Dim Sales_in_June As Chart
Set Sales_in_June = Charts.Add
Sales_in_June.SetSourceData Source:=Worksheets("VBA").Range("B4").CurrentRegion, PlotBy:=xlColumns
Sales_in_June.ChartType = xlPie
End Sub

Sample Data Set

Step 5:

  • Then, save the program and press the play button to run the code.

Sample Data Set

  • Finally, you will be able to see the pie chart that has been created through this VBA Code.

Sample Data Set


Notes:
  • While making the pie chart from the PivotTable give the correct table and worksheet reference. Otherwise, you will not get the output.
  • Be careful while copying or writing the code for VBA. If any of the signs from the code change randomly, then the code will not run.

Read More: How to Make a Pie Chart in Excel (Only Guide You Need)


Conclusion

That’s the end of this article. I hope you find this article helpful. After reading this article, you will be able to make a pie chart in Excel with one column of data by using any of the methods. Please share any further queries or recommendations with us in the comments section below.


Related Articles

Araf

Araf

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo