how to make a pie chart in excel for single column of data

You can follow the steps below to get familiar with this method. This procedure requires coding to make the pie chart. Applying VBA to Make a Pie Chart in ExcelĪpart from inserting PivotTable, you can also apply VBA Codes to make a pie chart in Excel with one column of data. How to Make Multiple Pie Charts from One Table (3 Easy Ways)Ģ.Group Small Values in Excel Pie Chart (2 Suitable Examples).How to Explode Pie Chart in Excel (2 Easy Methods).Make Pie Chart with Breakout in Excel (Step by Step).How to Create Pie Chart for Sum by Category in Excel (2 Quick Methods).Read More: How to Create a Pie Chart in Excel from Pivot Table (2 Quick Ways)

Finally, you will be able to make a pie chart with one column of data by following this method.For example, we will choose the Pie option under 2-D Pie.After that, you will see different pie models for the data sets.Then, go to the Insert tab from the ribbon and click on “ Insert Pie or Doughnut Chart” from the Charts.In the next step, after creating the PivotTable, select any cell from the table.Finally, you will see a newly inserted PivotTable next to your data set.From there, drag Sales in June 2022 to both Rows and Values at the bottom of the pane like the following picture.After clicking OK, a task pane named “ PivotTable Fields” will appear.For example, we will use cell D4 for this purpose.Then, select “ Existing Worksheet” and choose an empty cell near your data set.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, go to the Insert tab of the ribbon and choose PivotTable.For the following example, that is ( B4:B14).First of all, highlight the entire column of your data.The steps for this method are as follows. In this method, we will insert a PivotTable to make the pie chart in Excel with one column of data. Inserting PivotTable to Make a Pie Chart in Excel We will use the following data set for both the procedure.ġ.

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. In this article, you will see two easy ways to make a pie chart in Excel with one column of data. Sometimes, users need to make a pie chart from one column of data. In Excel, pie charts help users analyze data. 2 Handy Ways to Make a Pie Chart in Excel with One Column of Data

How to make a pie chart in excel for single column of data