Live Charts in PPT 2007



Is it possible to do the following:

1. Create an Excel Spreadsheet in PPT
2. Create a chart from the data in that spreadsheet
3. Link the embedded spreadsheet to the chart so that data changed in the
PPT reflects in the chart.
4. In presentation mode, keep the spreadsheet live to that I can change data
and have it reflect in the chart without dropping out of presentation mode?

I do a lot of sales presentations and I'm hoping to be able to update
information on the fly without "going behind the curtain."

Thank you.




1. Yes.

2. Yes.

3. Yes.

4. Don't think so but you could always do a Custom Show for this.

If my comments have helped please hit Yes.




Echo S

If you create a chart in PPT 2007, an Excel spreadsheet opens. Add your
data, close the spreadsheet.

This chart and the spreadsheet are embedded in PPT.

If you want a linked chart, you would open Excel, create the chart, save the
workbook, then copy/paste the chart into PPT. This creates a linked object
on the slide. You get an editable picture of the chart, but the data is
housed in a separate Excel file. This is new behavior in 2007. In previous
versions, pasting an Excel chart into PPT pasted the entire workbook into
the presentation, so there were no links. Just be aware of this change.

Hm. I'm not sure if you can have the chart update live. You might have to go
away from the chart and back to it after updating the linked spreadsheet.

You know, I've run slide reviews where I'm backstage, and the presenters are
looking at the big screen on the main stage. In those cases, I use the
Windows display to "extend monitor." I have the presentation open on the
laptop, and it's in presentation view on the big screen. I can make changes
to the deck in editing mode on the monitor, and they show up on the big
screen like magic. ;-)

I'm not set up to test it here, unfortunately, but I suspect that the
regular embedded charts would update also using this method and you wouldn't
even have to link them then.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question