Embed a set of dynamic calc charts in impress

Discuss the presentation application

Embed a set of dynamic calc charts in impress

Postby jonathanyates » Wed Jun 10, 2009 12:48 pm

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
jonathanyates
 
Posts: 1
Joined: Wed Jun 10, 2009 12:42 pm

Re: Embed a set of dynamic calc charts in impress

Postby acknak » Wed Jun 10, 2009 5:12 pm

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
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

Postby micha137 » Fri Jun 12, 2009 3:26 pm

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
micha137
 
Posts: 33
Joined: Mon Dec 03, 2007 12:25 pm
Location: Wedel/Germany


Return to Impress

Who is online

Users browsing this forum: No registered users and 3 guests