AI-made sales charts: 3 steps to check if table fixes reach them
Fixes to the original table may not reach an AI-made chart, so check its source and decide: record or live.
Key points
- Check the data range of the AI chart
- Record or live: decide for the chart
- Split by use: remake or chart the table
Overview diagram in preparation
Contents
Check in the data range which table the AI chart reads
A&A perspective
A chart's source is the cells of the table that the chart reads its numbers from. Before you use an AI-made chart in a weekly report, check this source first. Even when the chart is in the same file, it may not be reading your original sales table.
From the sources
In Google Sheets, you can call Gemini, Google's AI, from the top right of the screen and have it make a chart. According to the help, when you insert the chart, it is added to a new tab together with its underlying numbers. A tab is one sheet of cells within a single file.
From the sources
The chart is linked to the numbers in that new tab, and the help says the chart itself is fully editable. On the other hand, the help says that if the original numbers used to make the chart change, the chart does not reflect it. It also notes an exception: a chart made from a table connected to Google's BigQuery, which handles large data.
From the sources
The data range tells you which table the chart reads. Another help page describes the data range as the set of cells you want to include in your chart. Double-click the chart, open "Setup" on the right, and you will find a "Data range" field.
A&A perspective
Automate & Augment (A&A), which writes this article, reads it this way: if that field shows the name of the tab the AI added, the chart is looking at the numbers as of the time it was made.
A&A perspective
If you edit the numbers in the new tab, the chart changes too. But that means entering the same fix in two places, the original table and the new tab. It becomes easy to bring a chart to a meeting with only one of them fixed, so the two disagree.
Hypothetical example
For example, suppose an online food shop with 5 employees looks at last week's sales chart at the Monday meeting. After the meeting, the person in charge enters one cancellation into the original sales table. When they open that chart the next week, it still shows the numbers from before the cancellation.
Decide first whether the weekly chart is a record or live
A&A perspective
Once you have checked the source, decide how the chart will be used: keep it as that week's record, or keep looking at it with the numbers after fixes. The live chart is a chart you keep looking at with the numbers after fixes have been entered. Tidy up how the chart looks only after you have decided how it is used.
A&A perspective
The record shows what you looked at and what you decided at the time of the meeting. Even if a cancellation comes in later, it is more useful if it stays with that day's numbers. That an AI-made chart does not follow changes to the original table is not a problem for this use.
A&A perspective
The live chart is for working out next week's promotions and sales allocation using the numbers after fixes and cancellations have been entered. Here, it is a problem if fixes to the original table do not reach the chart.
A&A perspective
For a weekly report, some companies need only the record. Its main use is keeping what was decided at the meeting, and the next week they look at the next week's numbers. A live chart is needed when you decide your next move on the numbers after fixes. The trouble comes when you use a record as if it were a live chart. Because the chart is in the same file, it is easy to assume the fixes went in as well.
Hypothetical example
In the shop's case, the chart handed out at the Monday meeting is the record. When they review last week's best sellers on Wednesday with the numbers after the cancellation, they open the live chart. If they opened Monday's chart instead, they would be judging best sellers on the numbers from before the cancellation.
A&A perspective
The table below is a sample set of ground rules for the two kinds of chart. For each, it sets out the purpose, the period covered, what the chart reads, what to do when a fix or cancellation comes in, and who checks.
| Field | The record (that week's record) | The live chart (numbers after fixes) |
|---|---|---|
| Purpose | Keep what you looked at and decided at the meeting | Work out next week's promotions and sales allocation |
| Period covered | Write the date made and the week covered in the tab name | Write the period in the range, and whether added rows fall in the range |
| What the chart reads | The new tab the AI added | Cells in the original sales table, or a table that summarizes it |
| When a fix or cancellation comes in | Do not edit the tab. Put it in when you remake the chart next week | Fix the original table and compare with the chart's numbers |
| Who checks | The person who made it checks the date and the week covered | The person who entered the fix compares the numbers the same day |
Remake the record weekly; chart the original table for live use
A&A perspective
Remake the record with AI each week, and make the live chart an ordinary chart whose range is the original table. Building them differently keeps you from wondering which kind of chart you have opened.
A&A perspective
For the record, make the chart with AI before the meeting. In the name of the new tab that gets inserted, write the date it was made and the week it covers. Leave the previous week's tab as it is. If a cancellation comes in afterward, do not edit that tab. Put it in when you remake the chart the next week.
From the sources
According to the help, after the insertion a message at the bottom left confirms that a new tab was added. From there you can also delete the tab that was added.
A&A perspective
For the live chart, make a chart whose data range is cells in the original sales table, or in a table that summarizes it.
From the sources
You can choose the data range again from "Data range" under "Setup" for the chart. The help also says you can add ranges by clicking "Add another range".
A&A perspective
A&A keeps two things apart: being able to choose the range, and fixes and additions always reaching the chart. The help does not say how the chart changes when you edit cells inside the range or add rows outside it. So for the live chart, decide who will check after a fix is entered.
A&A perspective
The way to check is to compare the total in the original table with the number in the chart. The person who entered the fix does the comparison the same day. If they do not match, open the data range and look for rows that fall outside the range.
Hypothetical example
In the shop's case, the person who entered the cancellation on Wednesday compares that week's total in the original table with the number in the live chart. The record handed out at the Monday meeting is left as it is.
Summary
A&A perspective
For an AI-made chart, check in the data range field which table it reads.
A&A perspective
For the weekly sales chart, decide whether to keep it as that week's record or keep looking at it with the numbers after fixes.
A&A perspective
Remake the record with AI each week. Make the live chart from the original table as its range, and compare the numbers after each fix.
Before using an AI-made sales chart, check in the data range which table it reads. For the weekly sales chart, decide whether to keep it as that week's record or keep looking at it with the numbers after fixes. Remake the record with AI each week. Make the live chart from the original table as its range, and have the person who entered the fix compare the numbers the same day.
FAQ
If I edit the numbers in the tab the AI added, will it match the original table?
Because the chart is linked to that tab's numbers, editing that tab changes the chart. But you would be entering the same fix in two places, the original table and that tab. For the live chart, A&A thinks a chart whose range is the original table is less likely to leave a fix out.
Do fixes to the original table never reach any AI-made chart?
Not necessarily. The basis for this article is Google's help for Gemini in Google Sheets. The same help says a chart made from a table connected to Google's BigQuery, which handles large data, stays connected and shows the latest numbers when you refresh it. For AI charts from other tools, check on your own screen for the setting that corresponds to the data range.
Isn't it a lot of work to make both the record and the live chart?
It is some work. If you do not need a record of the meeting, the live chart alone is enough. If you need to explain later what was decided at the meeting, you need the record. Which one you need depends on who will look at that week's numbers later, and for what.
Sources & editorial note
Primary pages read for this article. Publication dates below belong to the sources; access dates record our research.
- Collaborate with Gemini in Google Sheets
Google Docs Editors Help · Not shown on the page
Accessed 2026-11-05 - Add & edit a chart or graph
Google Docs Editors Help · Not shown on the page
Accessed 2026-11-05