Excel Graphs in PowerPoint

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

REji - 03 Sep 2007 12:54 GMT

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
?

Reply to this Message

Brian Reilly, MVP - 03 Sep 2007 16:04 GMT

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

> 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
[quoted text clipped - 7 lines]
>solution for this
>?

Reply to this Message

REji - 04 Sep 2007 06:10 GMT

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

> You might be able to do this with an do Office 11 worksheet object.
>
[quoted text clipped - 22 lines]
> >solution for this
> >?

Reply to this Message

Ute Simon - 04 Sep 2007 13:56 GMT

> I have a 16 sheet work book wich contains Data & assumptions. In one sheet
> I
[quoted text clipped - 8 lines]
> 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

Signature

Ute Simon
Microsoft PowerPoint MVP Team und PowerPoint-User-Team
Blog, Tipps, Tricks und Newsletter unter www.ppt-user.de

Reply to this Message

REji - 05 Sep 2007 06:34 GMT

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

> > I have a 16 sheet work book wich contains Data & assumptions. In one sheet
> > I
[quoted text clipped - 21 lines]
> Best regards,
> Ute

Reply to this Message

Rate this thread: