View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
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.