Power Point Chart Excel File

JERRY89
4StarLounger
Posts: 516
Joined: 21 Feb 2016, 02:52

Power Point Chart Excel File

Post by JERRY89 »

Dear All,

May i know what is the trick on how to do the power point chart excel data link to my other workbook excel data.

User avatar
HansV
Administrator
Posts: 78481
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Power Point Chart Excel File

Post by HansV »

- Activate the Excel workbook.
- Select the chart.
- Press Ctrl+C or click the Copy button on the Home tab of the ribbon.
- Activate the PowerPoint presentation.
- Click the lower half of the Paste button on the Home tab of the ribbon.
- Select Paste Special...
- Select Paste Link.
- Click OK.
S290.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Power Point Chart Excel File

Post by Rudi »

If you are using Office 2010 or Office 2013, you just need to paste using the standard paste button (or CTRL+V).
A chart will always paste by default in these versions with a link to the source Excel file.

You can use the Smart Tag to change the paste format once the chart is on the slide.

The screenshot below shows the default paste setting which is using the Destination slide colour scheme and linking tot he Excel source.
Image 010.jpg
PS: I almost typed (CTRL+HansV) :laugh:
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
HansV
Administrator
Posts: 78481
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Power Point Chart Excel File

Post by HansV »

I'm not sure I would like to be Ctrl+clicked... :grin:
Best wishes,
Hans

JERRY89
4StarLounger
Posts: 516
Joined: 21 Feb 2016, 02:52

Re: Power Point Chart Excel File

Post by JERRY89 »

Hi Hans & Rudi,

Thanks a a lot for the info sharing .At last make me clearer on how to do my slide linkage.