Chart Tools questions usually focus on data refresh, image export, and missing entry points, with 3 common issue types covered below.
FAQ
Why does the chart not update automatically after I change the source data?
- Check whether you edited the cells that the chart actually uses as its source.
- If the chart does not refresh, reopen Edit Chart and confirm that the data range is correct.
- Make sure any newly added or changed data is still inside the chart's referenced range.
- Check the chart again after the range is corrected.
Will a chart image update automatically after I save it as a picture?
- No. An exported local image does not update with spreadsheet data changes.
- The original chart inside the spreadsheet can still change with its source data.
- If you need the latest image, update the chart first and then run Save as Picture again.
Why can't I see Chart Tools after selecting a chart?
- Make sure you selected a chart object rather than a normal cell or a picture.
- Try clicking the chart border or chart area again to reselect it.
- If the entry still does not appear, check whether the object in the file is an editable chart.
- If needed, insert a new chart and try again.
Glossary
| Term | Definition |
|---|---|
| Chart Elements | Display items that make up a chart, such as the chart title, axes, legend, and data labels. |
| Chart Style | A preset visual format for a chart, usually including colors, lines, and overall appearance. |
| Data Series | A group of related values in a chart that represents one category or measurement set. |