ICT Skills 4

If the information in your spreadsheet has changed, do you know how to update your chart? (27/32)

©ecolotrain — Updating charts

Find out

If you create a chart and then the data in your spreadsheet changes, you can modify or update your chart.

Use the Chart menu in the Chart toolbar, which is normally displayed when a chart is created.
Use the buttons and menu commands on the chart toolbar to modify your chart – change the chart type, format it, change the source data, add new data to the existing chart, specify other chart options, apply effects, etc.
If you do not see the Chart toolbar or want to hide it, go to View menu|Toolbars and click Chart.

Why is this information important for translators and translation teachers?
In the translation of spreadsheets, the chart title, captions and legend very often have to be translated, and so the chart has to be updated to display the translations.