This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

How do I create a chart in a spreadsheet that is automatically updated when the data is changed?

Follow these steps:

1. From the pull down menus, select: Tools > Options.
2. In the left column of the dialog that appears, select: Spreadsheet > General.
3. On the page that appears, in the Updating section under Update links when opening, click the checkbox next to Always.

Note: This is a global setting and will affect all spreadsheet charts and linked information from spreadsheets. If this is not desirable, click the checkbox next to On request. With this selected, a dialog box will pop up when each file with links to a spreadsheet is opened, where you can choose whether or not to update the item with newer information from the linked spreadsheet.

See also: How do I extend the range of data shown in my chart after I add new data to my spreadsheet?

Documentation / User FAQ / Calc / Previous-Next