AI GUIDEChoose the question first
A chart is useful when it answers a question more clearly than a table. AI can help clean labels, propose a suitable chart, calculate values with a tool and explain the result. It can also make an incorrect conclusion look polished. Start by deciding what you want to compare.
Use this fictional data: January, 20 lessons, 12 unique students; February, 24 lessons, 12 students; March, 18 lessons, 9 students. The question is whether lesson activity increased. This does not measure teaching quality or profit.
Type the data into a spreadsheet or paste it into a chat as clearly labelled rows. Use synthetic numbers while learning. Keep “lessons” and “students” in separate columns: they are different quantities.
Ask and check the maths
Prompt: “Using only these three rows, show total lessons, the change from January to February and a simple column chart of lessons by month. Keep students separate. Show the calculation and do not explain why the values changed without evidence. If you cannot run calculations or make a chart, say so and provide a table I can use.”
Check independently: 20 + 24 + 18 = 62 lessons. January to February is an increase of 4 lessons, or 4/20 = 20%. February to March is a decrease of 6, or 6/24 = 25%. The denominator changes with the comparison period.
For March, 18/9 = 2 lessons per unique student in that month. This is an average, not evidence that every student attended exactly twice. You cannot find unique students across the whole quarter by adding the monthly counts: the same person may appear in several months.
Make the chart readable
A column chart works for comparing these three monthly lesson counts. Put months on the horizontal axis and lessons on the vertical axis. Include the unit and a descriptive title. For this simple count comparison, start the vertical axis at zero so the bars do not exaggerate the differences.
If your assistant produces a chart, inspect the plotted values and labels. If it only suggests one, you can make it in Google Sheets: select the month and lesson cells, then choose Insert, Chart. Check the selected range and chart type in the editor. You do not need an AI subscription to draw this example.
Some AI systems can run code and generate chart files; others may only describe a chart. Those are different capabilities. Ask for the actual file or calculation result rather than assuming a fluent answer means code was executed.
Explain without inventing a cause
A sound caption is: “There were 62 lessons across the three months. February had the highest count, at 24. March had 18. The data does not state why the count changed.” An unsupported caption is: “The new AI programme increased engagement.” No programme or engagement measure appears in the source.
Exercise: change March's lesson count to a blank. The correct total is now unknown; you may report the known January–February subtotal of 44. Do not replace the blank with zero. Then label the 18 as cancelled lessons rather than completed lessons. Notice how the meaning changes even though the arithmetic does not.
You have learned the skill if you can explain the units, denominator, missing values and limits of the conclusion without relying on the assistant. Reuse the approach for household spending, support requests or agency workload, with data you are authorised to use.
Sources
Read the original sources to explore the topic and check specific claims.