how to make a pie chart in excel with multiple data

Next, click “Insert” at the top left of your window. Select the information and create the chartĬlick and drag the mouse to highlight all of the cells that contain categories or numbers by clicking on the cell in the top left corner. The program can match the value to the data category and produce a legend or guide for the chart by placing the values in the cell that is immediately below or next to their category. In order for Excel to assign proportions to each value and determine the size of the pie chart’s pieces, it must first calculate the total amount by adding the numbers in the second column.

The value for each category should be entered in your second row or column. Leave the first cell of that column or row empty if your categories are numbers so that Excel knows which axis contains the category names and which contains the values. You can enter the categories into a row or column with a single value in each cell to create the pie chart’s individual pieces.

A cell in Excel is a square into which you can enter either numerical or analytical data.

The size or name of each pie piece is typically determined by the value in a cell when pie chart data is used in Excel. Using Microsoft Excel, follow these four steps to create and modify a pie chart: 1. Click the chart and then click the icons next to the chart to add finishing touches:.Click Insert > Insert Pie or Doughnut Chart, and then pick the chart you want.In your spreadsheet, select the data to use for your pie chart.

How to make a pie chart in excel with multiple data