How to Make Multiple Pie Charts from One Table (3 Easy Ways)

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.

Ways to Make Multiple Pie Charts from One Table


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.

Using Pie Charts Feature to Make Multiple Pie Charts from One Table

  • 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.

Using Pie Charts Feature to Make Multiple Pie Charts from One Table

  • 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.

Using Pie Charts Feature to Make Multiple Pie Charts from One Table

  • 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.

Using Pie Charts Feature to Make Multiple Pie Charts from One Table

  • 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.

Using Pie Charts Feature to Make Multiple Pie Charts from One Table

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.

Applying Doughnut Chart to Make Two Pie Charts in One from One Table

  • 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.

Applying Doughnut Chart to Make Two Pie Charts in One from One Table

  • 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.

Applying Doughnut Chart to Make Two Pie Charts in One from One Table

  • Now, type Sales Analysis as Chart Title.

  • After that, click on the “+” sign to open Chart Elements.
  • Then, turn on Data Labels.

Applying Doughnut Chart to Make Two Pie Charts in One from One Table

  • 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


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.

Using VBA to Make Multiple Pie Charts from One Table

  • 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.

Using VBA to Make Multiple Pie Charts from One Table

  • 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

Using VBA to Make Multiple Pie Charts from One Table

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.

Using VBA to Make Multiple Pie Charts from One Table

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.

Make One Pie Chart from Multiple Tables

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.

Make One Pie Chart from Multiple Tables

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.

Make One Pie Chart from Multiple Tables

  • 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.

Make One Pie Chart from Multiple Tables

  • 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.

Make One Pie Chart from Multiple Tables

  • 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.

Make One Pie Chart from Multiple Tables

  • Then, select the 2-D Pie chart.

  • After that, click on the “+” sign to open Chart Elements.
  • Next, turn on Data Labels.

Make One Pie Chart from Multiple Tables

  • Finally, you will get one pie chart from multiple tables in Excel.

Make One Pie Chart from Multiple Tables


Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Section


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

Arin Islam

Arin Islam

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo