Question: How Do You Make A Pie Chart With Two Sets Of Data?

How do I add another set of data to a chart in Excel?

Right-click the chart, and then choose Select Data.

The Select Data Source dialog box appears on the worksheet that contains the source data for the chart.

Leaving the dialog box open, click in the worksheet, and then click and drag to select all the data you want to use for the chart, including the new data series..

How do you create a chart with multiple sets of data?

To create a combo chart, select the data you want displayed, then click the dialog launcher in the corner of the Charts group on the Insert tab to open the Insert Chart dialog box. Select combo from the All Charts tab. Select the chart type you want for each data series from the dropdown options.

What is the best chart to use for comparison?

Bar charts are good for comparisons, while line charts work better for trends. Scatter plot charts are good for relationships and distributions, but pie charts should be used only for simple compositions — never for comparisons or distributions.

How do I compare two sets of data in Excel?

Compare Two Columns and Highlight MatchesSelect the entire data set.Click the Home tab.In the Styles group, click on the ‘Conditional Formatting’ option.Hover the cursor on the Highlight Cell Rules option.Click on Duplicate Values.In the Duplicate Values dialog box, make sure ‘Duplicate’ is selected.More items…

What is a sunburst chart?

Sunburst Chart — also known as Ring Chart, Multi-level Pie Chart, and Radial Treemap — is typically used to visualize hierarchical data structures. A Sunburst Chart consists of an inner circle surrounded by rings of deeper hierarchy levels.

How do you rotate a pie chart?

Rotate a pie chartRight-click any slice of the pie chart > Format Data Series.In the Format Data Point pane in the Angle of first slice box, replace 0 with 120 and press Enter. Now, the pie chart looks like this:

How do I convert Excel data to a bar chart?

Open Excel. … Select all the data that you want included in the bar chart. … Click the Chart Wizard toolbar button, or choose Chart from the Insert menu.Make sure that Column is selected under Chart type (it’s the default setting).Select a subtype of bar graph from the display on the right, and click Next.More items…•

How do you make a double pie chart?

Double-click the slice you want to pull out, and then drag that slice away from the center of the chart….Follow these steps to do it yourself:Right-click the chart and then click Change Series Chart Type.Click Pie, and then click Pie of Pie or Bar of Pie.More items…

How do you calculate a pie chart?

Reading Pie Charts To calculate the percentage each slice is worth, measure the angle of each slice and divide this by 360 then multiply it by 100. To find the number of pieces of data each slice represents, multiply the percentage that each slice is worth by the total number of the data sets.

Can you add two data labels in Excel chart?

Right click the data series in the chart, and select Add Data Labels > Add Data Labels from the context menu to add data labels. 2. Click any data label to select all data labels, and then click the specified data label to select it only in the chart.

How do I select data for a pie chart in Excel?

To create a pie chart in Excel 2016, add your data set to a worksheet and highlight it. Then click the Insert tab, and click the dropdown menu next to the image of a pie chart. Select the chart type you want to use and the chosen chart will appear on the worksheet with the data you selected.

How do you put data into a pie chart?

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

How do I make a pie chart with two sets of data in Excel?

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 pie chart with one column of data in Excel?

Open the document containing the data that you’d like to make a pie chart with. Click and drag to highlight all of the cells in the row or column with data that you want included in your pie graph. 3. Click the “Insert” tab at the top of the screen, then click on the pie chart icon, which looks like a pie chart.