Arin Islam
Looking for ways to know how to make multiple pie charts from one table in Excel? We can make multiple pie charts from one table by going through some easy steps. Here, you will find step-by-step explained ways to make multiple pie charts from one table in Excel.
Download Practice Workbook
3 Ways to Make Multiple Pie Charts from One Table
Here, we have a dataset containing the data of Sales for consecutive 3 months January, February, and March of 5 Shops. Now, we will use this dataset to show you how to make multiple Pie Charts from one table in Excel.
1. Using Pie Charts Feature in Excel
In the first method, we will use Pie Charts to make pie charts from one table. Go through the steps to do it on your dataset.
Steps:
- In the beginning, select Cell range B4:C9.
- Then, go to the Insert tab >> click on Pie Chart >> select 2-D Pie chart.
- Now, a Pie Chart will appear containing the Sales data of January.
- After that, click on the “+” sign to open Chart Elements.
- Next, turn on Data Labels.
- Then, select Cell range B4:B9 and D4:D9.
- Afterward, go to the Insert tab >> click on Pie Chart.
- Next, select the 2-D Pie chart.
- Now, a Pie Chart will appear containing the Sales data of February.
- After that, click on the “+” sign to open Chart Elements.
- Then, turn on Data Labels.
- Next, select Cell range B4:B9 and E4:E9.
- After that, go to the Insert tab >> click on Pie Chart.
- Then, select the 2-D Pie chart.
- Now, a Pie Chart will appear containing the Sales data of March.
- Afterward, click on the “+” sign to open Chart Elements.
- Next, turn on Data Labels.
- Finally, you will get 3 separate Pie Charts for January, February and March from one table using Pie Charts.
Read More: How to Make a Pie Chart in Excel (Only Guide You Need)
2. Applying Doughnut Chart to Make Two Pie Charts in One from One Table
Now, we will show you how to apply a Doughnut Chart to make two Pie Charts in one from one table in Excel.
Follow the steps given below to do this on your own.
Steps:
- First, select Cell range B4:D9.
- Then, go to the Insert tab >> click on Pie Chart.
- After that, select the Doughnut chart.
- Now, a Doughnut chart will appear containing the Sales data of January and February.
- Next, select the smaller Doughnut chart.
- Then, the Format Data Series toolbox will open.
- Afterward, insert 0% in the Doughnut Hole Size box.
- Next, click on the Chart Title to change it.
- Now, type Sales Analysis as Chart Title.
- After that, click on the “+” sign to open Chart Elements.
- Then, turn on Data Labels.
- Finally, you will get two Pie Charts in one from one table by applying the Doughnut Chart.
Read More: How to Create A Doughnut, Bubble and Pie of Pie Chart in Excel
Similar Readings
- How to Change Pie Chart Colors in Excel (4 Easy Ways)
- Add Labels with Lines in an Excel Pie Chart (with Easy Steps)
- [Fixed] Excel Pie Chart Leader Lines Not Showing
- How to Create a 3D Pie Chart in Excel (with Easy Steps)
- [Solved]: Excel Pie Chart Not Grouping Data (with Easy Fix)
3. Using VBA to Make Multiple Pie Charts from One Table
In the final method, we will use VBA to make multiple pie charts from one table. Go through the steps to do it on your own.
Steps:
- In the beginning, go to the Developer tab >> click on Insert >> select Command Button.
- Then, insert CommandButton1.
- After that, Right-click on the button.
- Next, click on CommandButton Object >> select Edit.
- Now, type Create Pie Chart to edit the Command Button.
- Then, Right-click on the Create Pie Chart button.
- Next, select View Code.
- Now, you will see the code for CommandButton1_Click.
- Next, write the following code in your Module.
Option Explicit
Private Sub CommandButton1_Click()
Multiple_Pie_Charts
End Sub
Sub Multiple_Pie_Charts()
Dim Sales As Worksheet
Set Sales = Worksheets("Using VBA")
Dim sales_chart As ChartObject
For Each sales_chart In Sales.ChartObjects
sales_chart.Delete
Next
Dim Rng() As String
ReDim Rng(1 To 4)
Rng(1) = "C5"
Rng(2) = "D5"
Rng(3) = "E5"
Dim Sales_Pie_Chart As New Chart
Dim Sells_Series As Series
Dim row_number As Integer
Dim move_left As Integer
move_left = 10
For row_number = LBound(Rng) To UBound(Rng) - 1
Set Sales_Pie_Chart = Sales.ChartObjects.Add _
(Width:=170, Height:=170, _
Top:=210, Left:=move_left).Chart
With Sales_Pie_Chart
.ChartType = xlPie
.HasTitle = True
.ChartTitle.Text = Sales.UsedRange.Rows.Cells _
(3, row_number + 1)
Set Sells_Series = .SeriesCollection.NewSeries
With Sells_Series
.XValues = Sales.Range(Sales.Range("B5"), _
Sales.Range("B5").End(xlDown))
.Values = Sales.Range(Sales.Range(Rng(row_number)), _
Sales.Range(Rng(row_number)).End(xlDown))
End With
.SeriesCollection(1).HasDataLabels = True
End With
move_left = move_left + 180
Next row_number
End Sub
Code Breakdown
- First, we created Sub Procedure as Multiple_Pie_Charts().
- Then, we declared Sales as Worksheet.
- After that, we set the Sales from Using VBA Worksheet.
- Next, we declared sales_chart as ChartObject.
- Then, we created a For loop for each sales_chart in the Sales worksheet to delete previous charts while creating new charts.
- Afterward, we declared Rng() as String and redeclared Rng from 1 to 4.
- Next, we inserted Rng(1) =”C5″ ,Rng(2) =”D5″ and Rng(3) =”E5″.
- Then, we declared Sales_Pie_Chart as a New Chart, Sells_Series as Series, row_number as Integer and move_left as Integer.
- After that, we inserted move_left=10.
- Again, we used a For loop for row_number Lower Bound of Rng to Upper Bound of Rng subtracted by 1.
- Next, we set the Sales_Pie_Chart as a Chart containing Width=170, Height= 170, Top=210 and Left=move_left.
- Then, with the Sales_Pie_Chart we selected xlPie as ChartType, set Title as True and set the value as Cell (3, row_number+1) where values of the given row & column will be displayed as Chart Title.
- After that, with Sells_series we inserted XValues from the Sales worksheet as Cell B5.
- Moreover, we inserted Values from the Sales worksheet as Rng(row_number).
- Then, we set the Data Labels as True.
- After that, we inserted move_left= move_left+180 it will shift the Charts towards right and will create a gap between charts.
- Next, click on the Save button and go back to your worksheet.
- After that, click on the Create Pie Chart button.
- Finally, you will get 3 separate Pie Charts for January, February and March from one table using VBA.
Read More: How to Make a Pie Chart with Multiple Data in Excel (2 Ways)
Make One Pie Chart from Multiple Tables
We can also make one pie chart from multiple tables in Excel by going through some steps.
Here, the above data set shows the values of Sales of the Shops in January.
The above data set shows the values of Sales of the Shops in February.
Finally, the above data set shows the values of Sales of the Shops in March.
Now, we will consolidate the Sales value of the 3 months using the Consolidate Feature. Follow the steps below to do it on your own.
Steps:
- First, open a new Worksheet and prepare the worksheet for the consolidated data.
- Then, select Cell B4.
- After that, go to the Data tab >> click on Data Tools >> select Consolidate.
- Then, the Consolidate dialog box will open.
- Now, select Sum as Function.
- Next, in the Reference box insert the Cell range B4:C9 from the worksheet January.
- After that, press Add.
- Again, in the Reference box insert the Cell range B4:C9 from the worksheet February.
- Then, press Add.
- Now, in the Reference box insert the Cell range B4:C14 from the worksheet February.
- After that, press Add.
- Next, activate the Top row and Left column.
- Then, press OK.
- Finally, you will find the consolidated sum of Sales values of the three consecutive months applying the Consolidate Feature.
- Afterward, go to the Insert tab >> click on Pie Charts.
- Then, select the 2-D Pie chart.
- After that, click on the “+” sign to open Chart Elements.
- Next, turn on Data Labels.
- Finally, you will get one pie chart from multiple tables in Excel.
Practice Section
In this section, we are giving you the dataset to practice on your own and learn to use these methods.
Conclusion
So, in this article, you will find a step-by-step way to make multiple pie charts from one table in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!
Related Articles
- How to Make a Pie Chart in Excel without Numbers (2 Effective Ways)
- Create a Pie Chart in Excel from Pivot Table (2 Quick Ways)
- How to Explode Pie Chart in Excel (2 Easy Methods)
- Make Pie Chart with Breakout in Excel (Step by Step)
- How to Make Pie Chart by Count of Values in Excel
- How to Make a Budget Pie Chart in Excel (with Easy Steps)
