Once the pie chart appears on the spreadsheet, you can now right-click on it.Then, press “CTRL+A” to select all cells with information and then click the “Insert” tab and select the “Pie Chart” icon and choose the 2D pie chart. Start-off by adding the information about the chart to the cells in the spreadsheet.On that note, if you are trying to learn how to create a Pie Chart in Excel with percentage labels then follow the steps below. This is done to help readers who are not accustomed to reading this chart know what information you’re trying to relay. Although technically, each slices of the chart represents a certain percentage, it’s important to show it in numerical value. One of the most common form of Pie Chart that we see is the one with percentage values in it. How to Make a Pie Chart in Excel with Multiple Data.

How to Make a Pie Chart in Excel With Multiple Columns.This knowledge is what we’ll share here, as we will teach you how to make a Pie Chart in Excel using its native options. However, did you know that you can also make this chart using Microsoft Excel? This spreadsheet application can not only make tables and sheets, but also create various charts. They are just basically circles with divisions and labels. You can repeat this step for multiple data series, not just two.Pie charts are one of the easiest charts to make. Next, click on the Chart tab again and click the button for the other type of chart you want to combine here.

You'll create a chart of the selected type with both data series shown.Ĭlick on the chart representation of one of the data series - for example, if you selected a column chart, select on the columns showing the data you wanted in a line chart to select that data series within the chart. The most commonly used combination chart type mixes a column chart with a line chart. Be sure to include the cells with the labels in the selection area.Ĭlick on the 'Charts' tab in the ribbon and select a chart type from the 'Insert Chart' group. Select all the cells with data you want to include. Each data series needs to be in its own column or row and the number of cells used for each data series needs to be identical. Sales data broken down by month would be an example of a data series. Gather your data, making sure you organize it by the appropriate axes.

Create pie chart in excel 2016 mac