ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How Change Powerpoint Embedded Chart Values? (https://www.excelbanter.com/excel-programming/392426-how-change-powerpoint-embedded-chart-values.html)

MVP Wannabe[_2_]

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.

JLGWhiz

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.


JLGWhiz

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.


JLGWhiz

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.



All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com