How Change Powerpoint Embedded Chart Values?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Disregard that last message. You are looking for code to make the change and
I have not tried that myself.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Excel Chart into Existing Powerpoint Chart 1
VBA Public Function - Excel to PPT Stacked Chart, How to Remove Legends 0
Excel to Powerpoint 2003 Chart Width 2
XL2003 Embedded Charts 6
opening up Powerpoint slide from Excel 2
Embedded Chart protection 1
PasteSpecial Excel Chart in Powerpoint 2
Excel Referencing one cell from a different worksheet and slide in powerpoint 0

Back
Top