What element can you show or hide to improve clarity in the background of the chart?
Answer & explanation
Correct answer: option 2
The correct answer is Option (2) → Gridlines
Gridlines are the light horizontal and vertical lines drawn across the background of the plot area. They help the eye read a value off the axis, but when the chart looks crowded they can be hidden to make it cleaner. That is why they are listed with the axes as an element you can display or hide.
Option (1) Cell values — Incorrect. Cell values are the data in the worksheet from which the chart is drawn; they are not a background element of the chart.
Option (3) Data types — Incorrect. A data type (number, text, date) describes the contents of a cell; it is not something drawn on the chart.
Option (4) Legends — Incorrect. A legend can be shown or hidden too, but it is the key that names each data series, placed beside the plot, not the lines in the background.
NCERT (2026-27 edition):
|
