We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!

x

Interactive Excel Chart in Powerpoint

4,354 Views
Last Modified: 2010-05-18
Dear experts.

I'm trying to make a scientific powerpoint slide which shows an excel chart interactivelly.

In excel, i've done the complex scientific calculation, and shows the result in a chart.
The chart can be changed by modifying several cells that contains the calculation's parameters.
Until here, it works fine interactivelly.

Now, I want to impress my students, by showing that chart in a powerpoint slide interactivelly.
I  tried to link the chart in powerpoint (http://www.pptfaq.com/FAQ00593.htm).
This way, the chart in the powerpoint's slide can be changed interactivelly, BUT,
only by changing the parameter in Excel's worksheet, which is ugly.

How can I change the parameters from power point so I don't need to switch to excel during the presentation ?
I think I need to put a slider in the slide, then link it to the particular excel cell.
I just don't know how to make it happen.

Please help.

Comment
Watch Question

Try to Copy and paste instead of Copy and Paste link. Save powerpoint file and close the Excel file. You should now be able to double click the chart and do changes in power point without opening the Excel file.

Regards,
Curt

Author

Commented:
Hi epaclm,
That is possible while the powerpoint is in edit mode,
but not in slideshow mode.

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Forced accept.

Computer101
EE Admin
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.