← Excel Mastery

Lesson 3 of 4 · 7 min

Charts that tell a story

Use line charts for trends over time, bar charts for comparing categories and pie charts only for parts of a whole.

Always label axes and remove clutter — gridlines and 3D effects rarely help.

Practice

Chart monthly sales for a year and pick the chart type that best shows the trend.

Quiz

+50 pts
Show the festival’s growth

You have ticket sales for each of the last twelve months. The team wants to see the trend.

1. Which chart best tells that story?

2. Pie charts are for…

Optional resources

Your lesson toolkit

No purchase or partner signup is required to complete this course or earn quiz points.

These are official product links, not active affiliate links. Learnly does not currently earn a commission from them.

Excel for the web

Practice formulas and charts in a browser spreadsheet.

Free web version · Microsoft account required; desktop features may need a paid plan.

Explore tool