![]() |
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. |
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. |
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. |
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