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.
