#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3,101
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating Source Code in Charts University Charts and Charting in Excel 0 September 19th 06 08:12 PM
updating pie charts Lilsis7 Excel Discussion (Misc queries) 2 April 24th 06 01:21 PM
Automatic Updating Charts Rich Gibbons Charts and Charting in Excel 2 October 9th 05 11:36 PM
updating charts automatically Chris Charts and Charting in Excel 3 August 16th 05 03:18 PM
Updating charts in Excel Jeff M Charts and Charting in Excel 0 March 14th 05 04:45 PM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"