Excel reports: choosing the right chart

Sign up free to unlock this topic

Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.

Try the free sample: The ideal gas law · Have a class or homeroom code? Join here

Key idea: Excel reports: choosing the right chart

Pick the chart for the question you want to answer: a line chart for change over time, a column chart to compare categories, a pie chart for parts of one whole (only a few parts), and a scatter chart to see if two number columns are related.

Key words

Line
Trends over months or years.
Scatter
Two measures, one dot per row.

🔎 What to look for: If the parts don't add up to one whole, don't use a pie.

Zero2Hero — Zéro2Héros