Skip to content

In MS Excel, if you need to compare values over categories what type of chart would you use?

  1. A) Line chart
  2. B) Dot chart
  3. C) Pie chart
  4. D) Column chart
Show answer

Answer: D) Column chart

Explanation

A column chart. It shows each category as a separate vertical bar, so values can be compared side by side at a glance. A line chart is better for change over time, and a pie chart shows parts of one whole, not comparisons across many categories.

Asked in: MPEMR

Topic: Computer and IT