Faq/Writer/140

How to integrate a chart from a spreadsheet using linking
Context:


 * you wish to represent the data in a spreadsheet by using a chart; and
 * you wish the chart to be updated whenever the data in the spreadsheet change.

Linking by DDE
This technique consists of establishing a link with the data in the spreadsheet and creating the corresponding chart directly in the Writer document.


 * 1) open the spreadsheet, select and copy the data "source" for the chart (Menu  or );
 * 2) open the document in which you wish to create the chart;
 * 3) click in the document where you want the chart to be created;
 * 4) menu
 * This will create a Writer table; and
 * 1) select the whole table and go to . The chart is based on the table and can be modified cf. How to create a diagram or a chart;
 * 2) * by using the menu

Note: When the Writer document is opened, LibreOffice prompts you to update the links from the data.