![how to make a pie chart in excel with a hole how to make a pie chart in excel with a hole](https://www.statology.org/wp-content/uploads/2020/04/doughnut1.png)
- #How to make a pie chart in excel with a hole how to#
- #How to make a pie chart in excel with a hole full#
- #How to make a pie chart in excel with a hole mac#
Adding Data LabelsĪs it stands now, we don't know the exact percentages for each colored category. NOTE: We're dragging by the center because if we were instead to drag by a colored section (called a Category), the doughnut chart would disassemble itself-not what we want. Drag the doughnut chart by its center a bit to the right until the slide looks more balanced. The doughnut chart is a bit close to the legend. Move the legend down to the lower left where there is more room.ġ1. With the legend still selected, drag the horizontal and vertical bounding box handles to rearrange its content into two rows. In the Home tab, set the legend's font to Arial.ĩ. In the Legend Options panel that appears on the right, select Left to move it to the left of the chart.ħ. Right-click on the legend (the age categories) and select Format Legend.Ħ. In the (Chart) Format tab, in the Size section, set Height to 5.24" and Width to 7.96."ĥ.
#How to make a pie chart in excel with a hole mac#
(On Mac it just shows a doughnut with a bottom legend.) Quite snazzy for a click of a button, and it took care of deleting the Values text.Ĥ. In the upper right-hand corner, choose the third option, Layout 3. In the (Chart) Design tab and on the left side, click the Quick Layout button.ģ. Select the Chart Area by clicking in the area between the doughnut chart and the legend (the age categories).Ģ. The data was updated in PowerPoint! Styling the Doughnut Chartġ. We may need the exact sales numbers later.Ĩ. Formatting a value like 0.50% is another way to display percentages, but this way gives us more flexibility. NOTE: We will format these values as percentages later.
![how to make a pie chart in excel with a hole how to make a pie chart in excel with a hole](https://www.smartsheet.com/sites/default/files/styles/900px/public/ic-excel-pie-charts-3d-example.png)
Use the image below to fill in the rest of the data, pressing Tab or Return/Enter as needed: Our doughnut chart will display the total sales numbers per age group. Press Return/Enter to advance to the next cell in the column.ħ. Type: 15–24 (For proper typography, type an endash (–) by pressing Opt–(-) (Mac) or Alt–0150 on the number pad on the right of your keyboard (Windows).)Ħ. Because the bounding box has two columns (which is what we want), this selects A2, which represents an individual category.ĥ. Replace the text with: Values because it defines the data values for each category.Ĥ. Press Tab to move to the second header column, cell B1.ģ. This first header column lists the title that describes the categories (subsets of data) we are measuring.
#How to make a pie chart in excel with a hole full#
On Windows, it's a mini embedded version that doesn't have full functionality, which we don't need when working in PowerPoint.ġ. It displays the data associated with the chart. When the new chart appears on the slide, an Excel window opens. (Windows users will need to double–click on the last option.) Entering Chart Data in Excel In the center of the content placeholder, click on the Insert Chart icon.ġ0. In the title placeholder, type: Coworking Demographicsĩ. In the Home tab, click the arrow part of the New Slide button and choose Title and Content.Ĩ. In the Slides list, select the Line Chart slide (we just finished it).ħ. Double–click Pie Chart.pptx to open it.Ħ. Navigate to the Desktop > Class Files > yourname-PowerPoint 2016 Class folder.ĥ. Under Open, click on On my Mac or This PC.Ĥ.
![how to make a pie chart in excel with a hole how to make a pie chart in excel with a hole](https://thedatalabs.org/wp-content/uploads/2019/04/9-2.png)
![how to make a pie chart in excel with a hole how to make a pie chart in excel with a hole](https://www.smartsheet.com/sites/default/files/ic-excel-pie-charts-pie-of-pie-example-and-excel-pie-charts-bar-of-pie-example.jpg)
Still in PowerPoint, go to File > Open to open the next project.ģ. If you have any presentations open, in PowerPoint, go to File > Close to close them. NOTE: You will need to have Excel installed in order to complete this exercise.ġ. We'll be working with a variant of a pie chart called a doughnut chart.
#How to make a pie chart in excel with a hole how to#
In this exercise, you'll learn how to work with a pie chart.