The Free and Open Productivity Suite
Apache OpenOffice 4.1.8 released

This page is outdated. You will be redirected to /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

Apache Events

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.