![how to make a pie chart in excel 2020 how to make a pie chart in excel 2020](https://files.readme.io/dc7041e-pie_start.png)
If the linked chart isn’t open when the chart is updated in Excel, I open PowerPoint, select the chart, click the CHART TOOLS DESIGN tab, and click Refresh Data, which updates the chart.įor more information, see the course summary, and experiment some more with PowerPoint. If I have the linked copy of the chart open in PowerPoint, it updates automatically.
![how to make a pie chart in excel 2020 how to make a pie chart in excel 2020](https://spreadsheeto.com/wp-content/uploads/2019/03/pie_chart_workbook.png)
Sandoval’s portion in the chart expands to 13% and the other percentages adjust accordingly. I’ll click the cell, type the new amount of $1220, and press Enter.
#How to make a pie chart in excel 2020 update
The light background sets off the chart and I like the legend placed at the bottom.īack in the original Excel chart, let’s say I update the chart. Next, let’s click the CHART TOOLS DESIGN tab, and in Chart Styles, point to other possible styles for the chart. To position the chart, I’ll point to an edge and drag the four-pointed arrow cursor, eyeballing the placement for now. We can click X to close the Format Chart Area pane. Drag the Pie Explosion slider to increase the separation, or. To more precisely control the expansion, follow these steps: Right-click the pie chart, then click Format Data Series. Then, for Scale Height, I’ll increase the percentage to 200, and press Enter. The quickest way to pull all of the slices out of a pie chart is to click the pie chart and then drag away from the center of the chart. In the Size group, I’ll click the Size and Position arrow, and I’ll check Lock aspect ratio. To make it larger, I’ll leave it selected and click the CHART TOOLS FORMAT tab. Now, let’s adapt the chart to the presentation. I’ll choose the third option, Use Destination Theme & Link Data, which pastes and links the chart. The second two options link the chart, either using the destination theme or keeping the source formatting. The first two will embed the chart, either using the destination theme or keeping the source formatting. In PowerPoint, display the destination slide and right-click it. To copy and link the chart, right-click it, and click Copy to copy it to the Clipboard. When you keep a link to the chart, your updates to it are reflected in the PowerPoint version. If you prefer creating charts in Excel, create your pie chart there and copy it into PowerPoint.