Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series. Show To create a pie chart of the 2017 data series, execute the following steps. 1. Select the range A1:D2. 2. On the Insert tab, in the Charts group, click the Pie symbol. 3. Click Pie. Result: 4. Click on the pie to select the whole pie. Click on a slice to drag it away from the center. Result: Note: only if you have numeric labels, empty cell A1 before you create the pie chart. By doing this, Excel does not recognize the numbers in column A as a data series and automatically creates the correct chart. After creating the chart, you can enter the text Year into cell A1 if you like. Let's create one more cool pie chart. 5. Select the range A1:D1, hold down CTRL and select the range A3:D3. 6. Create the pie chart (repeat steps 2-3). 7. Click the legend at the bottom and press Delete. 8. Select the pie chart. 9. Click the + button on the right side of the chart and click the check box next to Data Labels. 10. Click the paintbrush icon on the right side of the chart and change the color scheme of the pie chart. Result: 11. Right click the pie chart and click Format Data Labels. 12. Check Category Name, uncheck Value, check Percentage and click Center. Result: Note: right click the data labels and click Font to change the font size and font color of the data labels.
Excel for Microsoft 365 Word for Microsoft 365 PowerPoint for Microsoft 365 Excel 2021 Word 2021 PowerPoint 2021 Excel 2019 Word 2019 PowerPoint 2019 Excel 2016 Word 2016 PowerPoint 2016 Excel 2013 Word 2013 PowerPoint 2013 Excel 2010 Word 2010 PowerPoint 2010 Excel 2007 Word 2007 PowerPoint 2007 More...Less Pie charts are a popular way to show how much individual amounts—such as quarterly sales figures—contribute to a total amount—such as annual sales. Pick your program(Or, skip down to learn more about pie charts.)
Note: The screen shots for this article were taken in Office 2016. If you're using an earlier Office version your experience might be slightly different, but the steps will be the same. Excel
PowerPoint
Word
Data for pie chartsPie charts can convert one column or row of spreadsheet data into a pie chart. Each slice of pie (data point) shows the size or percentage of that slice relative to the whole pie.
Pie charts work best when:
Other types of pie chartsIn addition to 3-D pie charts, you can create a pie of pie or bar of pie chart. These charts show smaller values pulled out into a secondary pie or stacked bar chart, which makes them easier to distinguish. To switch to one of these pie charts, click the chart, and then on the Chart Tools Design tab, click Change Chart Type. When the Change Chart Type gallery opens, pick the one you want.
See AlsoSelect data for a chart in Excel Create a chart in Excel Add a chart to your document in Word Add a chart to your PowerPoint presentation Available chart types in Office Need more help?How do you make a pie chart with percentages?Find the total of all values in the dataset. Divide each segment's value by the total, to get the corresponding percentage of the total for the pie chart. Multiply this percentage by 360° to calculate the degrees for the pie chart segment. Create a sector with this degree measure in the pie chart.
How do I calculate percentage in Excel chart?Basic Excel percentage formula. Enter the formula =C2/B2 in cell D2, and copy it down to as many rows as you need.. Click the Percent Style button (Home tab > Number group) to display the resulting decimal fractions as percentages.. |