| <meta http-equiv="REFRESH" content="10;url=http://wiki.services.openoffice.org/wiki/Documentation/FAQ"> |
| <h3>This page is outdated. You will be redirected to <a href="http://wiki.services.openoffice.org/wiki/Documentation/FAQ">http://wiki.services.openoffice.org |
| /wiki/Documentation/FAQ</a> shortly.</h3> |
| <div style="margin-bottom: 10em;"></div> |
| <p><a href="../../index.html">Documentation</a> / <a |
| href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a |
| href="009.html" accesskey="p">Previous</a>-<a href="011.html" |
| accesskey="n">Next</a></p> |
| <h3>How do I create a chart in a spreadsheet that is |
| automatically updated when the data is changed?</h3> |
| <p> Follow these steps:</p> |
| <ol> |
| <li>From the pull down menus, select: <b>Tools > Options</b>.</li> |
| <li>In the left column of the dialog that appears, select: <b>Spreadsheet |
| > General</b>. </li> |
| <li>On the page that appears, in the Updating section under <b>Update |
| links when opening</b>, click the checkbox next to <b>Always</b>.</li> |
| </ol> |
| <p><b>Note:</b> 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 <b>On request</b>. 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.</p> |
| <p><b>See also:</b> <a href="052.html">How do I extend the range of |
| data shown in my chart after I add new |
| data to my spreadsheet?</a></p> |
| <p><a href="../../index.html">Documentation</a> / <a |
| href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a |
| href="009.html" accesskey="p">Previous</a>-<a href="011.html" |
| accesskey="n">Next</a></p> |