Embed a set of dynamic calc charts in impress

Discuss the presentation application
Post Reply
jonathanyates
Posts: 1
Joined: Wed Jun 10, 2009 12:42 pm

Embed a set of dynamic calc charts in impress

Post by jonathanyates »

As the title states I would like to Embed a set of dynamic calc charts in impress. I have to update the managers each week using retail data in calc and about 20 graphs. What I would like to have is the ability to make the changes in the spreadsheet and when I am ready, save the calc sheet and simply open the impress file which will be updated with the latest updates from the calc sheet.

I can embed a calc sheet but this is not what I want, just the dynamic graphs.

Cheers for the help and for making my life simpler

Jonathan
OOo 3.0.X on Ubuntu 8.x
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Embed a set of dynamic calc charts in impress

Post by acknak »

What is Impress doing for you in this case? Do you have to make an actual presentation, or do you just have to give them the charts to look at?

If you don't need the presentation features, would a PDF made from Calc do the job?

As far as I know, there's no straightforward way to get what you want, other than copy/paste the charts into Impress.
AOO4/LO5 • Linux • Fedora 23
micha137
Posts: 33
Joined: Mon Dec 03, 2007 12:25 pm
Location: Wedel/Germany

Re: Embed a set of dynamic calc charts in impress

Post by micha137 »

From the menu:
Insert -> Object -> OLE Object -> Select "Spreadsheet" and "Create from File and mark "link" , then select your Spreadsheet.
Now just doubleclick the chart and move the window of the shown part to the chart.

regards
micha137
OOo 3.0.X on Ubuntu 8.x
Post Reply