The temperature and number sold are plotted y and x respectively and the revenue is shown by the size of the bubble. 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.In our example we are looking at ice cream sales: we want to explore the relationship between temperature, the number of ice creams sold and the revenue from those ice creams. 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.

Cannot create pie chart in excel 2013