Ask Your Question

Insert chart from calc into writer [closed]

asked 2015-11-29 17:14:00 +0200

EoghanM gravatar image

Rather than exporting a Calc chart as an image and then importing into Writer I'd like to be to insert a chart directly so that when the underlying data that makes the graph changes, those changes can be seen in Writer.

I tried inserting an OLE object but I only seem to be able to insert the entire spreadsheet. Any tricks?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-12 23:15:24.599665

1 Answer

Sort by » oldest newest most voted

answered 2015-12-02 08:57:44 +0200

pierre-yves samyn gravatar image


You can store the data in a table created directly in Writer, select the table then InsertObjectChart. It uses the table data. The table can optionally be inserted in a hidden section (menu InsertSection) if you do not wish to see the data.

It is also possible to integrate a chart from a spreadsheet using linking. This is described in this FAQ.


edit flag offensive delete link more


Thanks! Would never have found that DDE link functionality. Unfortunately when I change the spreadsheet, only the Writer table updates, not the chart based on the table. I have to manually modify one of the figures in the table before the chart updates itself.

EoghanM gravatar imageEoghanM ( 2015-12-02 18:01:26 +0200 )edit

@EoghanM - You can force the update of the charts in Writer by ToolsUpdateAll Charts (and of course Update All)

pierre-yves samyn gravatar imagepierre-yves samyn ( 2015-12-03 15:06:35 +0200 )edit

Question Tools

1 follower


Asked: 2015-11-29 17:14:00 +0200

Seen: 566 times

Last updated: Dec 02 '15