Creating a dynamic text box in PPT

[mcap74]

There are a number of slides that I update regularly. On these slides
is a chart with a set of time series data that I update monthly. On
these charts I have a text box that contains "Feb ratio = xxx%", where
xxx is the most recent data point on the chart. I would like to create
a text box that will automatically update when I add more data to the
chart. For example, I would like the box to read "March ratio = yyy%"
when I add March data.

I know how to do this in Excel but haven't figured out a way in
Powerpoint. Is this possible??

 

[Brian Reilly]

I'd probably try having a cell in Excel hold that data and have a
textbox in PPT to display that data. You could use OLE linking but it
would be safter to use the presentation.open event to open Excel
invisibly and get the text value of that Excel cell and set the text
of the PPT textbox to that string.

Brian Reilly, MVP

 

[mcap74]

Brian,

Thanks for the reply. While I am familiar with Excel, I am a
Powerpoint newbie. Could you give a little more detail about how to
set the PPT text box? Are you talking about cutting and pasting or is
there another method? Could you also explain how to use OLE linking?

Thanks,

Mike