How do you make a pie chart with two sets of data?

How do you make a pie chart with two sets of data?

Click on the first chart and then hold the Ctrl key as you click on each of the other charts to select them all. Click Format > Group > Group. All pie charts are now combined as one figure. They will move and resize as one image.

How do I create a 2d pie chart in Excel with multiple data?


  1. In your spreadsheet, select the data to use for your pie chart.
  2. Click Insert > Insert Pie or Doughnut Chart, and then pick the chart you want.
  3. Click the chart and then click the icons next to the chart to add finishing touches:

How do you add two series to a chart in Excel?

Working with Multiple Data Series in Excel

  1. Click Select Data button on the Design tab to open the Select Data Source dialog box.
  2. Select the series you want to edit, then click Edit to open the Edit Series dialog box.
  3. Type the new series label in the Series name: textbox, then click OK.

How do I create a side by side pie chart in Excel?

Thanks! Create the first chart, resize to size you want, create the second chart and resize. You can then select both charts by holding down the ctrl key, right click and select Group from the menu to Group the charts together. You can then copy and paste the two grouped charts into PowerPoint.

What is multiple pie chart?

The multiple pies chart is a visualization in which multiple pies are plotted together, side by side. While a single pie chart is used to visualize the part-to-whole relationship within one group, the multiple pies are mostly used to visualize and compare data of a category across different groups.

How do you make a 2 D pie chart in Excel?

To create 2-D Pie chart in Excel, first select the Chart data and go to INSERT menu and click on ‘Insert Pie or Doughnut Chart’ command dropdown under Charting group on the ribbon. You will see a Pie chart appearing on the page as displayed in the picture below.

How do you add another series to an Excel chart?

Adding a Series to an Excel Chart

  1. Click the chart to enable the Chart Tools, which include the Design and Format tabs.
  2. Click the “Design” tab, and then click “Select Data” from the Data group.
  3. Click “Add” from the “Legend Entries (Series)” section.
  4. Enter a name for the new data in the Series Name field.

What is dual bar chart?

A comparative bar chart (also known as a dual bar chart) shows a comparison between two or more sets of data. Whilst the chart below shows the favourite sports of a group of students, it further breaks down the data and gives a comparison between boys and girls; there are two bars for each sport.

What to consider when creating pie charts?

Consider grouping slices together in one bigger slice (e.g. “others”) to clean up the overall look of the chart. The bigger the slices, the easier they are to read (and the fewer labels you need). Consider placing the pie chart in a margin column or sidebar. Pie charts are not as flexible in width as e.g. bar charts.

How to calculate to make a pie chart?

using the formula.

  • Draw a circle using a pair of compasses.
  • Use a protractor to draw the angle for each sector.
  • 420 students in Year 2 and 630 students in Year 3.
  • How to create pie chart with examples?

    2D Chart. Click on Insert option that available on the top as shown in below image.

  • we will create PIE of PIE chart.
  • while creating the chart just select the Bar of Pie chart then the below chart will be created.
  • 3D PIE Chart.
  • Doughnut Chart.
  • What are the disadvantages of pie charts?

    pie chart becomes less effective.

  • and even if you add data labels and numbers may not help here.
  • You need a series to compare multiple sets as this chart only represents one data set.
  • Back To Top