4490 days on xHamster
13525M profile views
70372K subscribers
84760 comments left

Powerpoint graphs not updating

An advantage of this approach (for some) is that people you send the file to won't be able see your data or edit your graphs.

Because there is no need to store the data and settings, this approach doesn't take up so much disk space.

The advantage of embedding is that the Word or Power Point file is complete, containing the Prism data and settings.

One disadvantage is that this makes the Word file larger.

by Jim Gordon Microsoft Macintosh MVP Revised January, 2014 These instructions were designed for users of Macintosh versions of Microsoft Office 2011. Click in the document or on the slide where you want the graph to appear.

The instructions apply to Excel 2008 and Excel 2011 for Mac. Type the following into an Excel workbook to follow along with this example: Next, save the Excel workbook. In Word, the graph will appear at the blinking cursor position.

Another disadvantage (for some) is that it means your data can be stored in multiple places.

This will open a default graph in the Microsoft Graph program. If you have done this correctly, you should see the range selected and ìcrawling antsî around the data range in Excel. Next, switch back to the Microsoft Graph program (it has its own badge on the Dock, or use ALT TAB). Next, in Microsoft Graph, on the Graph menu choose EDIT Datasheet from the Microsoft Graph menu): and the graph will look like this after you pasted the linked data: You can customize the graph to your liking at this point. As soon as Microsoft Graph opens it will update the graph with the current information from the Excel workbook from which the graph was created and you can close Graph right away (Apple Q) to return to your updated document. Power Point MVP Shyam Pillai made a free add-in that updates links.When you double-click on a pasted picture, you cannot edit it within Prism.Instead, you'll open up a generic graphic or photo editor.You create desired functionality yourself using Visual Basic for Applications (VBA), which comes with Microsoft Office.I encourage everyone who has Microsoft Office to take a stab at learning vba.

Please or register to post comments
If spammers comment on your content, only you can see and manage such comments Delete all
Jan 16, 2013. Rating is available when the video has been rented. This feature is not available right now. Please try again later. Published on Jan 16, 2013. In this video tutorial we will show you how to update excel chart in PowerPoint. Don't forget to check out our site for more free how-to videos! 
24-Oct-2018 13:50
Jan 17, 2017. The update is not available when pasting tables. Second way is using Paste Special. Open the Excel workbook that has the chart that you want. Select the chart. On the Home tab, in the Clipboard group, click Copy or press Ctrl+C. Open the PowerPoint presentation, select the slide that you want to insert the. 
24-Oct-2018 13:54
However, my charts needs to be edited by some users. Paste special option does not allow users to edit the charts. Hence, I am unable to use this paste special option. I think the solution lies in writing a vba in powerpoint. Can any expert here offer to write this vba code to allow all the charts to be updated in powerpoint? 
24-Oct-2018 13:59

Powerpoint graphs not updating introduction

Powerpoint graphs not updating