Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default How Change Powerpoint Embedded Chart Values?

I have a Powerpoint slide with an embedded chart that I want to change the
values in (from Excel).

Typing ?ppslide.shapes(2).Name in the immediate window gives me the object
Object 2933, and I can select it, but I do not know the syntax to reference
the specific object cells A1:J1

Which methods and properties will get me to my end goal?

Thanks in advance.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default How Change Powerpoint Embedded Chart Values?

Two ways:

If your Excel source document is open, you can double click on the embedded
chart to activate it. See help in Power Point for Embedded Excel Charts.

If you don't care about updating your source file in Excel, you can update
the chart as a drawing object by clicking, draw ungroup do an edit then
regroup. See Power Point help file for Changing Embedded Charts without
Opening Source File.

"MVP Wannabe" wrote:

I have a Powerpoint slide with an embedded chart that I want to change the
values in (from Excel).

Typing ?ppslide.shapes(2).Name in the immediate window gives me the object
Object 2933, and I can select it, but I do not know the syntax to reference
the specific object cells A1:J1

Which methods and properties will get me to my end goal?

Thanks in advance.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default How Change Powerpoint Embedded Chart Values?

Disregard that last message. You are looking for code to make the change and
I have not tried that myself.

"MVP Wannabe" wrote:

I have a Powerpoint slide with an embedded chart that I want to change the
values in (from Excel).

Typing ?ppslide.shapes(2).Name in the immediate window gives me the object
Object 2933, and I can select it, but I do not know the syntax to reference
the specific object cells A1:J1

Which methods and properties will get me to my end goal?

Thanks in advance.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default How Change Powerpoint Embedded Chart Values?

You might get some ideas from this site:

http://peltiertech.com/Excel/XL_PPT.html


"MVP Wannabe" wrote:

I have a Powerpoint slide with an embedded chart that I want to change the
values in (from Excel).

Typing ?ppslide.shapes(2).Name in the immediate window gives me the object
Object 2933, and I can select it, but I do not know the syntax to reference
the specific object cells A1:J1

Which methods and properties will get me to my end goal?

Thanks in advance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
updating embedded powerpoint in excel file txm49 Excel Discussion (Misc queries) 0 September 24th 09 08:16 PM
Problem in updating the Powerpoint Embedded Chart with Excel figur Vinod Charts and Charting in Excel 0 May 4th 07 02:19 PM
In copied worksheet, embedded chart uses data fm orig - change? Harley Cudney Charts and Charting in Excel 2 April 15th 07 08:38 PM
Linked cells as embedded in PowerPoint luddite Excel Discussion (Misc queries) 0 February 25th 07 05:35 AM
Embedded chart along with DATA to powerpoint Hari Prasadh[_2_] Excel Programming 2 February 10th 05 08:54 AM


All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"