PC Review


Reply
Thread Tools Rate Thread

How Change Powerpoint Embedded Chart Values?

 
 
=?Utf-8?B?TVZQIFdhbm5hYmU=?=
Guest
Posts: n/a
 
      29th Jun 2007
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 With Quote
 
 
 
 
=?Utf-8?B?SkxHV2hpeg==?=
Guest
Posts: n/a
 
      29th Jun 2007
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.

 
Reply With Quote
 
=?Utf-8?B?SkxHV2hpeg==?=
Guest
Posts: n/a
 
      29th Jun 2007
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.

 
Reply With Quote
 
=?Utf-8?B?SkxHV2hpeg==?=
Guest
Posts: n/a
 
      29th Jun 2007
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting chart title from Embedded Excel Chart in PowerPoint Barb Reinhardt Microsoft Excel Programming 1 11th Jun 2008 02:22 PM
Extracting chart title from Embedded Excel Chart in PowerPoint Barb Reinhardt Microsoft Powerpoint 0 11th Jun 2008 01:31 PM
Change Scale In Embedded Xy Scatter Chart In Powerpoint =?Utf-8?B?Sm9obg==?= Microsoft Powerpoint 0 29th Jun 2007 10:48 AM
Change scale of a embedded excel chart in powerpoint using VBA Ram Chepyala Microsoft Powerpoint 1 16th Jun 2007 02:19 PM
Embedded chart along with DATA to powerpoint Hari Prasadh Microsoft Excel Programming 2 10th Feb 2005 08:54 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:45 AM.