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!