Theory
The number wall nobody reads
Meera proudly shows her husband twelve months of sales, twelve rows of numbers. He squints, shrugs: "So... is it going up or down?" He cannot see it in the digits.
She selects the same numbers, clicks one button, and a line climbing steadily upward appears. "Oh! Business is growing." One glance, understood.
That is a chart: numbers turned into a picture the eye reads instantly. The skill is not drawing it, Excel does that, but choosing the right type for your question.
Theory
A photo of your data
A table of numbers is like a written description of a person's face: accurate, but slow to picture. A chart is a photograph: you grasp it in one look. Different questions need different photos, a comparison photo, a trend photo, a share photo. Picking the wrong chart is like using a passport photo to show a landscape: technically an image, but useless for the question.
Follow along
Make a chart in Meera's sheet
- Select the data range, including the headings Highlight the item names and their sales numbers together.
- Insert tab, click the chart type you want Column, Line, Pie, Bar or Scatter, chosen by your question.
- Excel draws a live chart on the sheet Drag to position, resize by the corner handles.
- Add a title, and labels if needed Change any data value and the chart redraws itself instantly.
At a glance
Which chart for which question
| Chart | Best for | Meera's use |
|---|---|---|
| Column / Bar | Comparing values across items | Sales of each product |
| Line | A trend over time | Monthly sales growth |
| Pie | Parts of ONE whole (share) | Share of total by item |
| Scatter | Relationship between two numbers | Price vs quantity sold |
Quiz
Meera wants to show how her total monthly sales changed over the last 12 months. Which chart fits best?
- Line chart, it shows a trend over time
- Pie chart, it shows the 12 months
- Scatter chart, it lists the months
- No chart can show months
Show the answer
Line chart, it shows a trend over time
A line chart is built for trends over time: the rising or falling line makes growth or decline instantly visible. A pie would wrongly treat the 12 months as slices of a single whole (they are a sequence, not shares), and scatter is for correlating two numeric variables. Match the chart to the question: time trend equals line.
Think first
The living chart
Meera made her column chart last week. Today she corrects a wrong sales figure in the source cell. Does she need to redraw the chart? Think about what a chart is linked to.
Show the answer
No. A chart is linked live to its source data: change a value in the cells and the chart redraws itself automatically. Meera never touches the chart. This is the same live-connection idea as formulas, the picture is wired to the numbers. (This is also why deleting the source data breaks the chart.)
Watch out
Where marks leak
Forgetting to select the data first, the chart has nothing to draw. Using a pie for multiple series or a time sequence, pie is for parts of ONE whole only. Reaching for 3D by default: it looks fancy but the depth can distort which bar is taller, 2D is usually clearer and exams note this. And every chart needs a title and labelled axes, unlabelled charts lose presentation marks.
Theory
Charts are arguments
In your BCA project viva, a good chart makes your point before you say a word, and a wrong chart undermines you. The discipline, 'what question am I answering, and which picture answers it?', is real data-analysis thinking, the heart of this whole subject and of BCA602 (Data Analytics) later. Next lesson sharpens exactly one decision: when to use a column, a line, or a bar.
Summary
Key takeaways
- A chart turns numbers into a picture the eye reads in one glance.
- Select the data (with headings), Insert > chart type; the chart is linked live and auto-updates.
- Column/Bar compare values; Line shows a trend over time; Pie shows share of one whole; Scatter shows relationship.
- 3D adds depth but can distort; 2D is usually clearer.
- Always add a title and labelled axes.
- Memory hook: pick the right photo of your data for the question you are asking.