Video: Insert a linked Excel line chart

One way to insert a line chart into PowerPoint is to create the chart in Excel and copy it, keeping a link to the original, if you want.

To do that, when you are ready to copy the chart, right-click it, and click Copy to copy it to the Clipboard.

In PowerPoint, display the destination slide and right-click it.

You get several Paste Options.

The first two will embed the chart, either using the destination theme, or keeping the source formatting.

The second two options link the chart, either using the destination theme, or keeping the source formatting.

I’ll choose the third option, Use Destination Theme & Link Data.

That pastes and links the chart.

Now, let’s adapt the chart to the presentation.

To make it larger, I’ll leave it selected and click the CHART TOOLS FORMAT tab.

In the Size group, I’ll click the Size and Position arrow, and check Lock aspect ratio.

Then, for Scale Height, I’ll increase the percentage to 200, and press Enter.

We can click X to close the Format Chart Area pane.

To position the chart, I’ll point to an edge and drag the four-pointed arrow cursor, eyeballing the placement for now.

Next, let’s click the CHART TOOLS DESIGN tab, and in Chart Styles, point to other possible styles for the chart.

I see a preview when I point.

How about this one, Style 6.

The dark background adds great contrast.

Back in the original Excel chart, let’s say I update the chart.

For October, I’ll change Seattle’s Average Precipitation from 3.41 to 1.5 and press Enter.

The new average shows on the line in the chart.

If I have the linked copy of the chart open in PowerPoint, it updates automatically.

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.

That updates the chart.

For more information, see the course summary, and experiment some more with PowerPoint.