Graphs and charts
Choose an appropriate chart, select the right data and label its values and axes so a reader can interpret it accurately.
Exam scope and assessment notes
Cambridge IGCSE Information and Communication Technology 0417, for exams in 2026, 2027 and 2028. Examples, datasets and practice are original StudyForA material; they are not Cambridge questions, source files, mark schemes or grades. Practical lessons teach transferable operations, but learners must perform them in locally available office and web-authoring software and inspect their own files. This site does not reproduce a Cambridge practical examination or award an official grade. The separate 2029 syllabus is not mapped here.
Before you begin
- No previous ICT course is assumed. Read each scenario carefully and justify a tool or method by connecting it to the task, user and constraints.
Work on paper. Try each question before revealing help, and explain why your method works.
Quick readiness check
Which chart is generally suited to showing how a measure changes over ordered months?
What you will learn
- Select contiguous, non-contiguous or specified data ranges and an appropriate chart type.
- Add titles, labels, legends, axes, a second data series or second axis as required.
- Format values, scales and chart appearance without distorting the message.
Choose data and chart form
Select only the data required, including non-contiguous ranges when a task specifies separate columns. Use a chart type that matches the comparison: bars for categories, lines for change over ordered time, pie charts for parts of a whole when categories sum to one meaningful total.
A chart should have an informative title, category and value axis labels where appropriate, readable scales, data labels, a legend for multiple series and the requested currency or decimal format. A second axis may help compare different units, but can also mislead if its scale is unclear.
Format for truthful reading
Set minimum, maximum and increment values when required; ensure they do not exaggerate differences. A pie chart sector can be separated for emphasis, but the highlighted slice should not imply a different total. Use colours and fill patterns consistently and check that the chart remains readable in print and for the intended audience.
After editing the chart, verify that the plotted values correspond to the selected cells and that labels, legend and units are correct. A visually polished chart can still misrepresent data if its source range or scale is wrong.
Sources for this lesson
Pause and explain
A chart compares costs in dollars and delivery times in days. What could a second axis do, and what must be made clear?
Worked example
A manager wants to compare monthly sales for two product lines over one year. Choose a chart and name its key labels.
Show the worked solution
- Months are ordered categories, so a line chart can show change over time.
- Use one series per product line and add a legend.
- Label the chart title and value axis with the sales unit; check months and values.
Answer A two-series line chart can compare how both product lines change month by month. Give it a specific title, label the value axis with the currency or sales unit, retain month labels on the category axis and add a legend. Verify that both series use the same 12-month range.
Try a topic test
Choose Easy, Normal or Difficult. Save your answers and open worked review after finishing.
Test this topic →From guided practice to a new situation
Write your answer and reasoning first. Use a hint only if you are stuck. The model solution is for self-checking; your written work is not automatically marked.
A table lists revenue for each month in column B and costs for each month in column D, with notes in column C. How can both data series be charted without the notes?
Give me a hint
Select the category column and two non-adjacent value columns.
Compare my reasoning
- Select the month categories and revenue values.
- Add the cost range as a second non-contiguous series.
- Check the series names and every month before formatting.
Select the month range and revenue range, then add the cost range as a separate non-contiguous series, excluding the notes in column C. Confirm that each series uses the same 12 months and has a meaningful name in the legend.
Look for these in your work
- Uses the requested ranges
- Verifies category and series alignment
A chart's vertical axis starts at 950 for values from 950 to 1020, making a small change look enormous. Explain a fairer presentation.
Give me a hint
Make the scale and the size of the change visible without hiding the data range.
Compare my reasoning
- Consider whether the comparison needs a zero baseline.
- If a truncated axis is necessary, mark and label it clearly.
- State the actual values and check that the chart does not exaggerate the decision.
Use a zero baseline for a bar chart when relative magnitude is being compared. If a line chart uses a truncated range to show small changes, label the minimum and maximum and make the break or narrow scale clear. Include actual values so the apparent size is not mistaken for a huge absolute change.
Look for these in your work
- Explains why the scale matters
- Makes any truncation explicit
A pie chart shows five categories totalling 135% because one category was counted twice. What should be checked before formatting?
Give me a hint
Pie sectors should partition one meaningful whole.
Compare my reasoning
- Verify that each category is mutually exclusive and from the same total.
- Remove duplicated or overlapping categories and recompute percentages.
- Rebuild the chart and confirm the total represents 100%.
Check that categories are mutually exclusive and use the same denominator; the duplicated category must be corrected or removed. Recalculate the shares and confirm they sum to 100% (allowing for rounding) before creating the pie chart. Styling cannot fix an incorrect total.
Look for these in your work
- Checks source data before appearance
- Uses the whole-total condition
Common mistakes
- Using a pie chart for values that do not form one whole
- Truncating a scale without making the range clear
- Choosing data that accidentally omits a category or includes a total twice
What can you explain now?
Why must the chart data range be checked after selecting non-contiguous cells?
Compare with the explanation
To confirm that only the intended categories and values were plotted.
A wrong or incomplete range can produce a neat chart that communicates incorrect data.
After trying it yourself, choose your next review. This is your self-assessment.
Your review choice appears on Today. Sign in to sync it across devices.
Make it stick
Choose a chart for a time trend and one for parts of a whole, then list the labels each needs.
If you needed the solution, close it and solve the problem again from a blank page. A correct answer is stronger when you can explain the reason for each step.