Linking EXCEL charts into POWERPOINT

  • Thread starter Thread starter Anders
  • Start date Start date
A

Anders

I have generated a lot of charts, which resides inside an
MS EXCEL file. These charts are updated regularly and I am
required to present the results to management.
Questions:
1. Can I import these charts into my PPT file in a more
automatic fashin that what I use now, i.e. select the
chart in EXCEL, Copy and paste the clipboard in PPT?
2. When I do the copy and paste I get not only the chart,
but also the data behind the chart - the EXCEL data, for
EVERY chart I copy and paste. This means that the PPT file
grows rapidly! Is it possible to import only the chart to
PPT and not the data behind?
3. The ultimate solution would be that the graphs in my
PPT file are created from links to the graphs in my EXCEL
file, so if the EXCEL charts change, this will be visible
next time I open my PPT file. Is there such a possibility?
Thanks,
Anders
 
Hey Anders,

Ran into this problem myself and found the usual work-arounds if you don't
need the data and just an image of the chart:

1. Open in slide sort. Copy the the slide and paste back into the
presentation. Enlarge. Delete the original. This turns the whole slide into
an image, which you can crop. This gets tedious if you have a lot of charts.

2. I had an size issue (for emailing) and found an inexpense aplication
called NXPLite.exe. Since I also deal with a lot of images too, this little
program works wonders for me. As far as charts, it flattens all charts, beit
from any other program, and turns them into uneditable images. This
application can down-sized a presentation by as much as 90%...depending on
content, especially with imgz. You can then zip it for more compression.

Just do a search for NXPLite on the web...you'll find it easy enough.

Enjoy,
Lou
 
[This followup was posted to microsoft.public.powerpoint with an email
copy to Anders.
Please use the newsgroup for further discussion.]

As Steve pointed out in his post, in PP use Edit | Paste Special... |
Paste Link option to maintain a link between the XL object pasted into
PP and the actual object. Now, updating the PP presentation with new
data is trivial.

As far as the data getting copied with the chart goes, that is new to
me. For years, I've done the following with great success: In XL,
select the chart, then Copy (CTRL+c). Switch to PP. Use the paste
link option. Resize the object in PP as desired. Never copies/shows
the data behind the chart!

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
As far as the data getting copied with the chart goes, that is new to
me. For years, I've done the following with great success: In XL,
select the chart, then Copy (CTRL+c). Switch to PP. Use the paste
link option. Resize the object in PP as desired. Never copies/shows
the data behind the chart!
Click to expand...

But if you simply paste instead of Paste Link, you get an OLE embedded
object instead of a linked one, and in that case the whole XLS file is there
for the taking.
 
Hi Steve,

But if you simply paste instead of Paste Link, you get an OLE embedded
object instead of a linked one, and in that case the whole XLS file is there
for the taking.
Click to expand...

Yeah, but one still shouldn't see any of the worksheet that contains
the chart! Or am I missing something?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Tushar,
In addition to Steve's comments, let me add a Bovey'ist idea.
In Excel, select the chart sheet and choose Edit, Copy As New Workbook
and you have a single chartsheet or single worksheet with a chart in a
new single sheet workbook (could also do the chart sheet and identify
the .Sourcerange worksheet and grab that too). Then if you copy and
paste the new workbook into PPT, you have a single/double sheet
workbook and the data. No real file bloat.

Alternatively, if you just copy and paste the single sheet (workbook)
chart sheet into PPT, it is still linked to the sourceworkbook and
will update the link if the OLE object is activated.

Brian Reilly, PowerPoint MVP
 
Back
Top