AccountancyCBSE Class 12 · Graphs and Charts for Business Data

Elements of a Chart and How to Format Them: Class 12 Spreadsheet Guide

Updated 15 October 2026 · Fact-checked

A chart is built from elements: the chart area (the whole chart), plot area (bounded by the axes), data points and data series, horizontal (category) and vertical (value) axes, legend, chart and axis titles, data labels and gridlines. Each element can be formatted for fill, outline, effects, text and internal margin.

Notice that the plot area sits inside the chart area, and the legend tells you which colour is which data series.

Illustration drawn for QuestionBuddy.

Understand Chart Elements and Formatting

Elements of a chart.

Chart area: the entire chart and all its elements.
Plot area: the region bounded by the axes where data are drawn (X and Y in 2-D; X, Y and Z in 3-D).
Data points / data markers: individual values shown as bars, columns, points or slices.
Data series: related data points of one row or column, shown in one colour or pattern.
Horizontal (category) axis and vertical (value) axis; 3-D charts add a depth (series) axis.
Legend: key identifying each data series by colour or pattern.
Chart title and axis titles: descriptive text.
Data labels: the value, percentage or category name shown on a data point.
Gridlines: lines across the plot area to read values.

Pie and doughnut charts have no axes; radar charts have no horizontal axis.

Formatting an element. Select it (click it, or pick it from the Chart Elements drop-down) → right-click → Format <element>, or use the Format tab: Shape Fill, Shape Outline, Shape Effects (shadow, glow, 3-D), WordArt and text options.

Layout/Chart Elements: add, remove or position titles, legend (right, top, bottom, left), data labels (centre, inside end, outside end), axes and gridlines.
Axis options: minimum, maximum, major unit, number format, display units.
Data series options: gap width between columns, overlap, secondary axis.
Internal margin: for text in chart elements and shapes, the distance between the text and the element's border, set separately for left, right, top and bottom (Format → Text Box/Alignment options).

Why format? A well-formatted chart is easier to read: clear titles, readable labels, sensible scale and colours that separate series.

Chart Elements and Formatting: key facts

Main elements: Chart area, plot area, data points/series, axes, legend, titles, data labels, gridlines
Formatting path: 1.Select element
2.right-click
3.Format <element> (or Format tab)
Internal margin: Distance between text and the element border: left, right, top, bottom

How to answer Chart Elements and Formatting questions

Questions ask you to identify an element, explain it, or describe how to change its format.

1Identify the element from the description (whole chart, area inside axes, key, labels on points).
2State its purpose in one line.
3To format: select the element, open Format <element>, choose fill, outline, effects or text.
4To add or remove: use the Layout tab or Chart Elements button.
5For axis scale, use axis options (minimum, maximum, major unit).
6Mention internal margin for spacing of text inside elements.

Chart Elements and Formatting in real life

The idea, met in an everyday situation. Answer the question in your own words, then compare with the model answer. The one-line hook is what to remember.

Data labels and legend

Suppose a café owner shows her partners a pie chart of monthly expenses, but they keep asking 'which colour is rent?' and 'what percentage is wages?'.

Which chart elements should she add or format to answer both questions on the chart itself?

Try it first, then show the solutionSolution

Add a legend (or category names in data labels) so each colour is identified.
Add data labels showing percentages on each slice.
Add a chart title such as 'Expense share, March'.

Answer: She should show the legend (or category names) to identify each slice and data labels with percentages to show each share, plus a clear chart title; then the chart answers both questions without explanation.

Memory hook: Legend says who; labels say how much.

Tricks to remember Chart Elements and Formatting

Short memory aids. Say each one aloud once, then use it on a question the same day.

Area outside, plot inside
Chart area holds everything; plot area is only the space within the axes.
Use it when: Distinguishing the two.
Series = same colour
All markers of one colour form one data series.
Use it when: Data series questions.
Margin = breathing space
Internal margin is the gap between text and border on four sides.
Use it when: Internal margin MCQs.

Chart Elements and Formatting: solved examples

Ordered from board level to HOTS. Try each one before you open the solution.

Example 1: Which element? · 1 mark · MCQBoard level

The chart element that identifies each data series by its colour or pattern is the:
(a) data label
(b) legend
(c) plot area
(d) axis title

Try it first, then show the solutionSolution

The legend is the key to colours or patterns of series.

Answer: (b) legend

Example 2: Explain three elements · 3 marks · Short answerBoard level

Explain chart area, plot area and data labels. (3 marks)

Try it first, then show the solutionSolution

Chart area: the whole chart including all elements.
Plot area: the region bounded by the axes where data are plotted.
Data labels: text on data points showing their value, percentage or name.

Answer: As explained.

Example 3: Formatting a data series · 3 marks · Short answerHarder board level

Describe how to change the colour of one data series in a column chart and reduce the gap between its columns. (3 marks)

Try it first, then show the solutionSolution

Click a column of that series to select the whole series.
Right-click → Format Data Series → Fill → choose a colour.
In Series Options, reduce Gap Width; close.

Answer: Select the series → Format Data Series → change fill and Gap Width.

Example 4: Axis scale · 3 marks · Short answerHarder board level

A column chart of monthly sales between ₹80,000 and ₹1,00,000 starts its value axis at 0, so differences look tiny. How can the axis be changed, and what caution applies? (3 marks)

Try it first, then show the solutionSolution

Select the vertical axis → Format Axis → Axis Options.
Set Minimum to, say, 70,000 and choose a suitable major unit.
Caution: a non-zero start exaggerates differences; label the axis clearly so readers are not misled.

Answer: Change the axis minimum in Format Axis, but label it clearly because a truncated axis magnifies differences.

Example 5: Internal margin · 1 mark · Assertion-reasonHOTS / competency

Assertion (A): Internal margin of a chart element can be set separately for its left, right, top and bottom sides.
Reason (R): Internal margin is the distance between the text and the border of the element.
(a) Both A and R are true, and R is the correct explanation of A.
(b) Both A and R are true, but R is not the correct explanation of A.
(c) A is true, but R is false.
(d) A is false, but R is true.

Try it first, then show the solutionSolution

Both are true; R defines internal margin but does not explain why it can be set per side.

Answer: (b) Both A and R are true, but R is not the correct explanation of A.

Where students lose marks in Chart Elements and Formatting

The slips examiners see most often, and what to write instead.

Mistake: Calling the plot area the chart area
Similar names.
Wrong working
'Chart area is the space within the axes.'
Right working
That is the plot area; chart area is the whole chart.
Do this: Outside vs inside.
Usually costs: 1 mark.
Mistake: Saying a pie chart has axes
Listing elements of every chart.
Wrong working
Pie chart: category and value axes.
Right working
Pie and doughnut charts have no axes.
Do this: Adjust the element list to the chart type.
Usually costs: 1/2 mark.
Mistake: Confusing legend with data labels
Both are text on the chart.
Wrong working
Legend shows each bar's value.
Right working
Legend identifies series; data labels show values.
Do this: Key vs value.
Usually costs: 1 mark.
Mistake: Vague formatting steps
Not naming the dialog.
Wrong working
'Change colour of chart.'
Right working
'Select series → Format Data Series → Fill → colour.'
Do this: Name the element and dialog.
Usually costs: 1/2 mark.

Exam tips

List elements with one-line meanings; marks are per element.
Use the exact dialog names: Format Data Series, Format Axis, Format Chart Area.
Mention internal margin when asked about text spacing in elements.
Chart elements and formatting appeared as 6-mark board items recently; expect explanation plus steps.

Practice questions on Chart Elements and Formatting

Write each answer on paper first. Open the hint only if you are stuck, and the answer only when you have finished.

Q1 · 1 mark · MCQBoard level
The area bounded by the axes of a chart is the:
(a) chart area
(b) plot area
(c) legend
(d) data table
Hint
Inside the axes.
Answer
(b) plot area
Q2 · 1 mark · MCQBoard level
Related data points shown in the same colour form a:
(a) data label
(b) data series
(c) gridline
(d) chart title
Hint
Same row or column.
Answer
(b) data series
Q3 · 1 mark · Very short answerHarder board level
How do you move the legend of a chart to the bottom? (1 mark)
Hint
Layout tab or Chart Elements.
Answer
Select the chart → Layout (or Chart Elements) → Legend → Show Legend at Bottom.
Q4 · 3 marks · Short answerHarder board level
Explain the three axes of a 3-D column chart. (3 marks)
Hint
Category, value, depth.
Answer
Horizontal (category) axis: shows categories such as months. Vertical (value) axis: shows the values. Depth (series) axis: the third axis showing the different data series in 3-D.
Q5 · 3 marks · Short answerHarder board level
List four options available when formatting a chart element on the Format tab. (3 marks)
Hint
Shape and text.
Answer
Shape Fill, Shape Outline, Shape Effects (shadow, glow, 3-D) and WordArt/text styles (also size and arrange options).
Q6 · 1 mark · Assertion-reasonHarder board level
Assertion (A): Data labels can show the percentage share of each slice in a pie chart.
Reason (R): Data labels display information about individual data points on the chart.
(a) Both A and R are true, and R is the correct explanation of A.
(b) Both A and R are true, but R is not the correct explanation of A.
(c) A is true, but R is false.
(d) A is false, but R is true.
Hint
Labels on points.
Answer
(a) Both A and R are true, and R is the correct explanation of A.
Q7 · 3 marks · Short answerHOTS / competency
Suppose a chart for a board meeting has a long title that touches the border of its text box and looks cramped. Which formatting setting fixes this and how? (3 marks)
Hint
Internal margin.
Answer
Increase the internal margin of the title: select the title → Format Chart Title → Text Box/Alignment → set left, right, top and bottom margins larger; this adds space between the text and the border.
Q8 · 3 marks · Short answerHOTS / competency
A line chart compares sales (₹ lakh) with the number of customers (hundreds), but the customer line is flat near zero. How can the chart be formatted so both are readable? (3 marks)
Hint
Secondary axis.
Answer
Select the customer series → Format Data Series → Series Options → Plot Series On: Secondary Axis. The customers get their own scale on the right; add axis titles for both axes.

Test your recall

Answer in your head or on paper first, then open the card. Pulling an answer out of memory makes it stick far better than re-reading.

1.What is the chart area?Show answer
The whole chart including all its elements.
2.What does a legend show?Show answer
Which colour or pattern represents each data series.
3.What is internal margin?Show answer
The distance between text and the border of a chart element.
4.Which charts have no axes?Show answer
Pie and doughnut charts.
5.Which dialog changes a series' colour?Show answer
Format Data Series.

Chart Elements and Formatting: frequently asked questions

What are the elements of a chart in Class 12?

Chart area, plot area, data points and series, category, value and depth axes, legend, chart and axis titles, data labels and gridlines.

How do I format a chart element?

Select it, then right-click → Format <element> or use the Format tab for fill, outline, effects and text.

What is the difference between chart area and plot area?

The chart area is the whole chart; the plot area is only the region inside the axes where data are drawn.

What is a data series?

A set of related data points from one row or column, shown in the same colour or pattern.