<< Click to Display Table of Contents >> Updating charts

A chart always retrieves the values to be displayed from the cells that were selected when the chart was created. If values in these cells change, the chart is automatically updated and immediately shows the changed values.

Disabling automatic update

If desired, you can disable this automatic updating. To do so, choose the ribbon command File | group File management | Properties, switch to the Calculate tab and disable the option Update automatically in the Charts section.

If this option is disabled, the charts in the current document will only be updated when you initiate this manually via the ribbon command Formula | group Update | Update data | Update charts.