Excel Graphs in PowerPoint

[Guest]

I have a 16 sheet work book wich contains Data & assumptions. In one sheet I
summarised all the results and assumptions into a Graph with Controls like
Spin Buttons, Options buttons, etc. If I change values using the Spin
buttons, correspondingle the graph will be changed.

Now I want to export this graph along with the controls into my powerpoint
presentation with or without teh whole excel file. When we normally paste the
graph into Powerpoint slide, it can't be dynamic, i.e we can't change the
values during the presenttaion in slide itself. Can anybody suggest any
solution for this
?

 

[Brian Reilly, MVP]

You might be able to do this with an Office 11 worksheet object.

On the View menu, choose toolbars and choose Control Toolbox. The last
icon which has a hammer and what might be a wrench is how you get to
the Office 11 objects, not the familiar Insert Object + Excel
worksheet manner.

On this toolbar click the hammer icon and insert object Office
worksheet or Office chart and draw the shape on the PPT page. You can
right click on these objects to get at the code or the Properties.

It will not be a trivial task.

Brian Reillly, MVP

 

[Guest]

Dear Mr. Brian Reilly,

Thank you very much for the reply. But I tried toas you said. If I insert
the spin button from Control Tool box as you said from hammer icon, how it
can be linked to the graph. Also I try to insert the Excel working sheet in
the slide, but there also I can't insert the controls and moreover on
presentation the excel sheet is shown. I want to export the graphs with
controls only.

Please help me through a step by step procedure please

Thanks in advance

 

[Ute Simon]

I have a 16 sheet work book wich contains Data & assumptions. In one sheet

I
summarised all the results and assumptions into a Graph with Controls like
Spin Buttons, Options buttons, etc. If I change values using the Spin
buttons, correspondingle the graph will be changed.

Now I want to export this graph along with the controls into my powerpoint
presentation with or without teh whole excel file. When we normally paste
the
graph into Powerpoint slide, it can't be dynamic, i.e we can't change the
values during the presenttaion in slide itself. Can anybody suggest any
solution for this

Are you presenting this yourself? Why not use Excel to present the data? If
you have to forward the graph to a client, I could understand that
PowerPoint sounds like the easier way. But I don't know a possibility to do
it.

You could show your Excel graph full-screen, with Tools - Options remove all
menu and toolbars, adjust it to window size and maybe add some color. Then
open PowerPoint with your Excel graph running in the background. When you
need to show the graph, just switch from PowerPoint to Excel with Alt+Tab.

Best regards,
Ute

 

[Guest]

Dear Friend,

thanks for the reply. but the excel graph is part of my project
presentation. So to show the effect of changing the variables i have to show
the samin PowerPoint and not switching into Excel. So Please help me