how to make a pie chart in excel for budget

If I have the linked copy of the chart open in PowerPoint, it updates automatically. 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. 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. Then, for Scale Height, I’ll increase the percentage to 200, and press Enter. 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.

How to make a pie chart in excel for budget