A survey is not a chart. A chart is the second step
Friends write answers into a form or a column. Raw rows apple, Apple, roll are not a chart yet. First you count how many times each answer appeared. Then a small table. Then a chart.
Today you go the whole way: survey → totals → a column → a PNG for a report.
From answers to a table
Assume sheet Survey (or make it). Column A: raw answers. Column B maybe Count — empty for now.
-
Unify answers. Filter or by hand:
appleandApple→ oneapple. Delete spaces at the end. Without that the chart shows three “different” apples. -
In D1:E5 make a summary table:
D E Answer Count roll 8 apple 5 bar 4 nothing 5 Write the counts from a filter or by hand after adding. 22 in total — check
=SUM(E2:E5). -
Select D1:E5. Insert → Chart → Column. Chart title = the survey question:
What do you have at break? -
Axis Y:
Number of votes. Turn data labels on. The highest column = the winner. -
Three dots on the chart → Download → PNG. Rename
survey-snack.png.
Always a chart from a table Answer + Count, not from a column with 22 names. Two columns, headings in row 1, no extra average. Range D1:E5, not the whole sheet.
A sentence under the chart
Into a cell under the chart write one sentence from the table, not by eye:
The most common snack is a roll — 8 votes of 22 (36 %).
A percent: =E2/SUM($E$2:$E$5) in a helper column, or you work it out in your head. Into a report belongs a sentence + PNG + a PDF of the sheet (in the next lesson).
What often goes wrong
A chart from column A. 22 rows of text = 22 columns or chaos. A summary first.
A forgotten total. Counts do not match the number of answers. SUM must be 22.
Title “Chart 3”. Title = the survey question. Always.
🏫 Grade average — another project
Do not put a survey and grades into one chart. Two sheets, two charts. The dashboard later shows grades — leave the survey on sheet Survey with its own PNG.
💰 Pocket money — not a survey
Pocket money is not a vote. Do not add money into the survey. If the survey is “how much do you spend a day”, the same steps: a summary table, then a chart.
📊 Class survey — the whole path
A form → export into column A → tidy the text → table D:E → a chart → PNG → a sentence under the chart. This is a template for every survey in the course.
🏆 Mini dashboard — only the result
On the dashboard do not copy 22 rows. Sao chép the chart from the survey or only the sentence “winner: roll”. Raw data stays on Survey.
Now you 💪
First: summary table D1:E5, a chart, labels, a PNG.
Second: a sentence under the chart with a number and a percent. Change one count in the table — the column and the sentence must recalculate (the percent via a formula).
Check: SUM of counts = the number of people. A chart from D1:E5. A named PNG. Title = the question.
What to take from this lesson
- Survey → a summary table → a chart. Never a chart straight from text answers.
- Chart title = the question. A sentence under the chart = a number from the table.
- PNG + a sentence = the base of handing in a survey.
© 2026 Ing. Martin Polak / AlgoRhino · Điều khoản sử dụng nội dung