asked on

Interactive Excel Chart in Powerpoint

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.

Curt Lindstrom

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

Kocil

ASKER

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

ASKER CERTIFIED SOLUTION