charts
1 sub-question across 1 paper, 6 marks total.
Computer Applications Technology 2026
In the Impact worksheet create a clustered column chart showing Start-ups by Sector for Q1–Q4, with a descriptive title, axis labels and a legend as in the example.
Show answerHide answer
Select the table including headings: Sector, Q1, Q2, Q3, Q4 (A1:E6).
Insert → Charts → Clustered Column.
Chart Design → Add Chart Element → Chart Title → edit to something descriptive, e.g.
Start-ups by Sector per Quarter.Add Chart Element → Axis Titles → Primary Horizontal:
Sector; Primary Vertical:Number of start-ups.Add Chart Element → Legend → Right (shows Q1–Q4).
Add Chart Element → Data Labels → Outside End (the example shows values above the bars).
Why this earns the marks
marks: chart type, correct data series, title, horizontal axis label, vertical axis label, legend — six separately checkable pieces of chart configuration, each added through its own step in Add Chart Element. Sectors should appear along the bottom with four coloured bars each, because a clustered column chart's category axis (the bottom) is whichever dimension of the data was treated as "groups," and series (the four colours within each group) is whichever was treated as "categories within a group" — exactly the chart-from-a-sheet logic covered in the integration notes. If Excel puts Q1–Q4 on the bottom instead, use Chart Design → Switch Row/Column, which doesn't recalculate anything, just swaps which axis is treated as which. The example's default title "Sector" and axis labels "Time frames" / "Companies" are placeholders, but the paper asks for a descriptive title, so write something meaningful: a chart's auto-generated title is usually just the name of the first data series or column, which rarely actually describes what the chart shows.