PC Review


Reply
Thread Tools Rate Thread

Change sheet on imported Excel chart

 
 
=?Utf-8?B?RXZhX1M=?=
Guest
Posts: n/a
 
      26th Apr 2007
I have an Excel document with one chart per sheet and many sheets. I now made
a PowerPoint (PPT2003) where I would like to import one chart per slide. I
can open the Excel-file and the correct sheet, import it (as object) into
PowerPoint - fine! I can do the next chart the same way on slide 2. However
when I update the links they all end up being the same chart. What am I doing
wrong? No fun to have a Powerpoint file with many slides where all the slides
have the same chart!

Help!
 
Reply With Quote
 
 
 
 
Steve Rindsberg
Guest
Posts: n/a
 
      26th Apr 2007
In article <40DA49C4-5DD0-488B-B1DC-(E-Mail Removed)>, Eva S wrote:
> I have an Excel document with one chart per sheet and many sheets. I now made
> a PowerPoint (PPT2003) where I would like to import one chart per slide. I
> can open the Excel-file and the correct sheet, import it (as object) into
> PowerPoint - fine! I can do the next chart the same way on slide 2. However
> when I update the links they all end up being the same chart. What am I doing
> wrong? No fun to have a Powerpoint file with many slides where all the slides
> have the same chart!


Do it the other way round ....

Open your Excel file, select the first chart and Edit/Copy.

Now switch to PPT, go to the slide where you want the chart and choose Edit,
Paste Special, Link.

Repeat for each chart.



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================


 
Reply With Quote
 
=?Utf-8?B?RXZhX1M=?=
Guest
Posts: n/a
 
      2nd May 2007
Thanks a million, Steve!

;-)
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
remove bullet from sheet in Excel, imported from Powerpoint Paul Microsoft Excel Misc 2 5th May 2010 04:43 PM
set y-axis length on chart imported from excel Mike Williams Microsoft Powerpoint 0 8th Mar 2010 07:35 PM
Why is Excel sheet concatenated when imported into Word? =?Utf-8?B?S2V2aW5SNw==?= Microsoft Excel Misc 0 6th Oct 2006 06:55 PM
Excel: Can I change Chart-title/category/value from a sheet-cell? =?Utf-8?B?ZmVta2U=?= Microsoft Excel Charting 4 24th Oct 2005 04:55 PM
How can I add an auto number to an imported sheet from excel? =?Utf-8?B?TWFyeUU=?= Microsoft Access External Data 5 18th Aug 2005 09:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:58 AM.