Enable changing source files of linked Excel charts from Powerpoint
When an excel chart is inserted in powerpoint the data och the chart is linked to an excel spreadsheet.
In the windows version it is possible to change the source file of the linked data. It is not possible to do this in powerpoint 2016 for Mac.
Removing the “Under Review” tag since this idea does not have sufficient votes for us to take on as a new feature.
We want to make sure the User Voice site is up to date with the engineering efforts we are making. Please continue submitting ideas and voting.
Scott, why do you ignore people's requests like this? It's a very basic one. Disappointing.
Under review for coming up on 2 years now. Any updates from the team, please? And please add Mac support for linking to excel charts, worksheets, ranges etc, just as can be done under Windows.
Fabian Voß commented
This is a real essential feature in reporting and management!
PS: I recently posted and pictured the exact same situation in a longer post on a Microsoft Help Community. Maybe not on point, but possibly useful when (hopefully) fixing that issue soon: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_powerpoint-mso_mac-mso_o365b/office-mac-powerpoint-does-not-update-linked-data/1c601937-0bdc-43e3-8934-2901e362e4fa
I would also like to vote for this idea. Thank you!
I rely on this function, as I produce monthly reports in a 80 page doc, each page slide of which contains multiple graphs. Sometimes I move computers, or the file moves, or the file name is updated to reflect the current year. For each of these I need to update the source file path and name. Please assist ASAP. I'm considering moving back to windows if I have to spend days on this robotic task each month. Thank you.
This is a no-brainer, because as a user you end up in a dead end situation with no other option than starting all over again...
Inexcusable to not have this feature.
Its in PC I believe this should be in the Mac version (I only have access to mac and have to use the XML hack in the mean time)
You should just be able to right click on the chart and change the source data file.
PIerre Lionnet commented
This is a mandatory feature. Please make it happen.
Please YES, give the Mac the ability to link to spreadsheet data & charts. Not having this is like running a footrace with your feet amputated.
Kenneth Stanigar commented
A long overdue, and necessary, improvement.
Rohonesh Kar commented
It will be very useful to have this feature because then you can have one excel sheet linking to different charts in your powerpoint as against having to maintain multiple worksheets for one powerpoint presentation!
I think that is a good idea.