Which of the following purposes does not pertain to charts?

Selecting values

The correct answer is option 2- Selecting values.

Selecting values is not any purpose that pertain to chart.

Charts in Excel are primarily used for:

Identifying trends (e.g., sales increasing over time)

Recognising patterns (e.g., seasonal effects)

Making comparisons (e.g., comparing revenues across departments)

Graphs and charts help in easy visualisation of any trends present in data. In highly random data such as stock prices, textual description may not be easily possible to explain the price or other fluctuations, but graphs and charts overcome this constraint as they can be comprehended more easily by human beings. Pictorial representations include Pie Chart and Bar Chart. Pie charts depict relative share of different elements. Bar charts are used to depict the comparison of absolute values of data (e.g. sales, production, etc.) at discrete points (e.g. time intervals, products, etc.).