create pie chart in excel from one column

Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% See screenshot:Ĭreate a pivot chart by count of values in Excel Now the clustered column chart is created based on the occurrence of each value. Select both the pasted column and formula column, and click Insert > Insert Column or Bar Chart (or Column) > Clustered Column. Note: In the formula =COUNTIF($A$2:$A$24,E2), $A$2:$A$24 is the fruit column in source data, and E2 is the first unique value in the pasted column.Ħ. Select the blank cell beside the first value of the pasted column, type the formula =COUNTIF($A$2:$A$24,E2) into the cell, and then drag the AutoFill Handle to other cells. Please click the OK button to close it.ĥ. Now the Microsoft Excel dialog box comes out.

Keep the pasted column selected, click Data > Remove Duplicates, and then click the OK button in the popping out Remove Duplicates dialog box. Select a black cell, and press Ctrl + V keys to paste the selected column. Select the fruit column you will create a chart based on, and press Ctrl + C keys to copy.Ģ. This method will guide you to create a normal column chart by the count of values in Excel.

Create pie chart in excel from one column