Linking Excel Data to PPT Charts data sheet

[fritz78]

I was asked a question by a work colleague on linking excel data to create
charts in PPT. Is linking the excel data directly to the PPT chart data
sheet, creating chart type, and formatting in PPT the best way to do this? I
thought creating the charts in Excel on there own chart sheet then copy,
paste link the chart into a PPT slide and resizing for desired look may be
easier. They are looking to create a slide with 4 charts with consistentcy.
I know some problems come up when you copy excel data into the PPT chart data
sheet. Any suggestions would be appreciated.

PPT 2002, Excel 2002.

 

[Echo S]

Don't link the data to the chart sheet -- the chart won't update until you
go in and manually open the chart.

Your way is better.

Here's the FAQ about the charts not updating properly. Maybe that will help
you explain why it's not a good idea.
http://www.rdpslides.com/pptfaq/FAQ00025.htm