Lesson 3 of 5 · about 5 min
Summary tables and charts
When you finish, you can plan a pivot-style summary, choose a chart that fits your question, and avoid misleading visuals.
Stuck? Ask the AI tutorStart with the question
A summary table answers a question. “How much did each region sell each month?” is a question. “Make a pivot table” is not. When the question is clear, the layout almost writes itself: what goes down the side, what goes across the top, and what gets added up.
Tell the AI your columns and your question. Ask it to explain which column belongs in rows, which in columns and which in values. Then build the table yourself in your spreadsheet program, following the steps. You learn the skill and avoid trusting a table you cannot reproduce.
Checks for any summary
Every summary should pass two simple checks. First, the grand total should match a total you calculate another way. Second, the count of rows should match what you expect. If a region disappears, a blank or a spelling variant is likely hiding it.
Ask the AI: “How can I check that this summary is complete and correct?” It might suggest comparing totals, looking for blank categories, or filtering one category by hand. These checks take a minute and prevent embarrassing mistakes in a meeting.
Choosing a chart
Different questions need different charts. Change over time suits a line. Comparing categories suits bars. Parts of a whole can use a simple bar or a pie with very few slices. A weak request is “Make a nice chart.” A strong one is: “I want to show a school board that attendance dropped in winter. Data is monthly attendance. What chart fits and what should the title say?”
Ask the tool to name a chart that would mislead. Common traps: a bar chart whose axis does not start at zero, too many colors, or a 3D effect that distorts sizes. Clear titles and labels matter more than decoration.
Worked example: a clinic’s supply costs
A small clinic in Dhaka tracks monthly supply costs. The manager asks: “Which category is growing fastest?” With the AI, she plans a table with months across, categories down and costs as values, and a line chart with one line per category.
She checks that the grand total matches the accounting sheet. One category appears twice because of a spelling difference. After fixing it, the chart is clear. She writes her own one-line title: what she wants the board to notice. The tool helped with structure, but the message is hers.
Practice now
- Take a small data set of your own, with private details removed, and write one clear question it could answer. Ask an AI tool how to build a summary table for that question, then build it.
- Ask for a chart recommendation and a chart that would mislead. Write a plain-language title that states what the reader should notice.
Use any AI assistant you have. Do not paste private, client or patient information into it.
Check yourself
1. What should come before building a summary table?
2. Which chart is usually best for change over time?
3. A region is missing from your summary. What is a likely cause?
Ask the AI tutor
Ask anything about this lesson, in any language. The tutor is an AI: it can be wrong, and it never needs your personal details.
AI-drafted. Checked by an automated validator and a separate AI reviewer; a person has not read every lesson. Translations and tutor answers are AI-made. Found a mistake? Tell us. AI can be wrong. General information only, not professional advice. Not affiliated with any AI company named. Current University is not accredited.