Re: Update "buildin" excel in a powerpoint with macro

On 30 Maj, 05:15, Jim Gordon MVP <goldke...@xxxxxxxxxxxxxxxxxxxxxx>
wrote:
Hi,

Thanks for the reply. That is helpful.

In the setup you are using the Excel data source workbook exists somewhere
as file. When you double-click the embedded graph object Excel should open
and you can then edit the data directly.

I want to be sure I reproduce the setup exactly as you have done it.

Does the data range for the chart exist on the same work*** as the chart
in Excel, or is the graph on a chart work***?

Am I correct that what we need to do is to tell Excel to "calculate" on
demand which will result in new values for the data set, which presumably
has the RANDOM cell function in the cells? And then we need to refresh the
chart so that it reflects the new values but without going to the trouble of
opening Excel to work on the embedded chart? You want to click a button
perhaps and just have the data refresh? Or maybe mouse-over something on the
slide to trigger the update?

If I have it right, please post back. If I have it wrong please post
corrections.

It is not the same as Insert > Object > Excel chart. If you were to Insert >
Object > Excel chart the Excel data source would exist inside the PowerPoint
presentation file as an embedded object. Some of the behavior is the same as
your setup, but in this case there is no .xls file anywhere else on your
computer

Thanks.

-Jim Gordon
Mac MVP

Quoting from "Tithe...@xxxxxxxxx" <Tithe...@xxxxxxxxx>, in article
1180472766.382304.20...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx, on [DATE:



On 28 Maj, 18:27, Jim Gordon MVP <goldke...@xxxxxxxxxxxxxxxxxxxxxx>
wrote:
Hi,

There is at least 4 possible ways you could have created linked charts.
Please let us know which method you followed:

* Link to data that's contained in an excel workboook already saved as a
file somewhere
* Insert > Object > Microsoft Excel Workbook
* Insert > Object > Microsoft Excel Chart
* Insert > Object > Microsoft Graph Chart

Each of the above methods will behave differently, but all of them can
produce charts that are linked to a data table and can be refreshed.

Thanks.

-Jim Gordon
Mac MVP

Quoting from "Tithe...@xxxxxxxxx" <Tithe...@xxxxxxxxx>, in article
1180295035.655949.82...@xxxxxxxxxxxxxxxxxxxxxxxxxxx, on [DATE:

Hello
I got a huge problem that I hope you people can help me solve. I am
trying to create a powerpoint with my mac (version 2004 of ppt) and I
got some excel charts that generates random numbers and calculates
abit in my powerpoint and when watching the powerpoint I want the
watcher to have the ability to "refresh" the excel charts to get new
random numbers but I have no idea how to do this. I thougt about doing
a macro but I lack the skills to create it so I wonder if somone could
help me with this.

/ Tithe...@xxxxxxxxx

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP infohttp://mvp.support.microsoft.com/

I hope you can help me.

I did the following:
insert -> object ->then chosed from file then selected a file and
prest ok
Guess that is the same as:
insert->object->excel chart

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP infohttp://mvp.support.microsoft.com/

Hi again!

First I belive the excel chart I got in my presentation does not exist
anywhere else on the computer (at least not visible), because I can
remove the files I imported too the powerpoint without any problems,
and the presentation works just like before. So I belive it is a excel
chart embedded in my presentation.

And yes, the only thing we need to do is to force the excel charts in
the presentation to update so it generates new random numbers, without
leaving the presentation or opening the excel charts. And I want a
button to press so it updates.

I hope I answerd all the questions you had, if not tell me what I
missed.

.

Loading