nsame.blogg.se

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