How do you display or hide the horizontal and vertical axes in a chart?
Answer & explanation
Correct answer: option 3
The correct answer is Option (3) → By selecting primary or secondary axes display
A chart in a spreadsheet has two axes: the horizontal (X) axis, which carries the categories, and the vertical (Y) axis, which carries the values. Showing or hiding them is a layout choice for a chart element: you select the chart and choose to display (or hide) the primary axes, and, where a second data series is plotted on its own scale, the secondary axes.
Option (1) By inserting formulas — Incorrect. Formulas calculate values in cells; they do not change what a chart displays on its axes.
Option (2) By resizing the plot area — Incorrect. Resizing makes the chart or its plot area bigger or smaller; the axes stay as they are.
Option (4) By deleting chart elements — Incorrect. Deleting removes an element altogether; the question asks how to display or hide the axes, which is done through the axes display option.
NCERT (2026-27 edition):
|
