Share via

Powerpoint graph structure does not update when source excel graph is changed

Anonymous
2022-09-14T09:42:04+00:00

I have a column chart in excel with let's say three columns x1, x2, x3.

I have copied it and pasted into powerpoint presentation (Keep Source Formatting &Link Data) and "Automatic" update checkbox is checked.

Once excel chart values change everything is reflected in powerpoint chart when opening powerpoint and updating links.

However, if excel chart structure changes, let's say additional column x4 is added, powerpoint chart does not update accordingly (It looks like powerpoint chart is not linked with excel chart, but rather data in excel).

Is there a way to solve this/workaround to have powerpoint charts to remain identical to excel charts?

Microsoft 365 and Office | PowerPoint | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Steve Rindsberg 99,161 Reputation points MVP Volunteer Moderator
    2022-09-14T15:28:42+00:00

    In creating the link, did you start in PPT and choose Insert Object | Create From File | Link?

    If so, that's likely the problem.

    Instead, start in Excel. Copy the chart there, then switch to PowerPoint and chose to Paste Special | As Excel Chart and checkmark Link.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments