How to Create a Pie Chart in Excel with One Data Column - 2 Methods

This is the sample dataset.

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

Method 1 – Inserting a PivotTable to Create a Pie Chart in Excel

Step 1:

Select the entire column. Here, B4:B14.

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

Step 2:

Go to the Insert tab and choose PivotTable.

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

Step 3:

In “Select a table or range”, you will see the selected range (B4:B14).
Select “Existing Worksheet” and choose an empty cell near your dataset. Here, D4.
Click OK.

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

Step 4:

In “PivotTable Fields”, drag Sales in June 2022 to both Rows and Values.

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

The PivotTable is displayed.

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

Step 5:

Select any cell in the table.

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

Step 6:

Go to the Insert tab and click “Insert Pie or Doughnut Chart” in Charts.

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

Step 7:

Choose a pie model. Here, 2-D Pie.

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

The pie chart is displayed.

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

Method 2 – Applying VBA to Create a Pie Chart in Excel

Step 1:

Use the following dataset:

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

Step 2:

Go to the Developer tab and choose Visual Basic.

Sample Data Set

Step 3:

In the Insert tab, choose Module.

Sample Data Set

Step 4:

Enter the following VBA Code.

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