Updating Charts
 

Hi, I've got a question for you all! I have an Excel spreadsheet, and a
Powerpoint presentation. From the spreadsheet, a lot of the points are being
used to make charts in the presentation (approx 12 charts). These need to be
updated with new data every week, and I'm growing tired of entering in new
data, changing each chart by hand (or computer...), then copy and pasting the
new charts back into the old presentation. There must be a way that I can
enter my new points, and have Office do the rest of the work, updating the
charts in Powerpoint, no? Does anyone know how I can do this? I do know
that I can update an individual chart by opening the chart from Powerpoint,
and altering the spreadsheet there. That only affects the one chart, though.
I would like to be able to alter ONE spreadsheet, and have ALL the charts
updated automatically. Can anyone help me with this, or is this something I
am doomed to tediously type out every week? Thanks so much!

Updating Charts
 

When you change the data in the chart's source data range, the chart (in
Excel) should update automatically. Make sure calculation isn't set to
manual mode (Tools Options Calculation tab).

Then copy each chart, switch to PowerPoint, and use Edit menu Paste
Special Paste Link. This puts a linked picture of the chart into the
slide, which will update formats and data to keep up with the Excel chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Mike" wrote in message
...
Hi, I've got a question for you all! I have an Excel spreadsheet, and a
Powerpoint presentation. From the spreadsheet, a lot of the points are
being
used to make charts in the presentation (approx 12 charts). These need to
be
updated with new data every week, and I'm growing tired of entering in new
data, changing each chart by hand (or computer...), then copy and pasting
the
new charts back into the old presentation. There must be a way that I can
enter my new points, and have Office do the rest of the work, updating the
charts in Powerpoint, no? Does anyone know how I can do this? I do know
that I can update an individual chart by opening the chart from
Powerpoint,
and altering the spreadsheet there. That only affects the one chart,
though.
I would like to be able to alter ONE spreadsheet, and have ALL the charts
updated automatically. Can anyone help me with this, or is this something
I
am doomed to tediously type out every week? Thanks so much!