Excel practice · Dashboarding

Excel charts practice exercises

5 graded problems with realistic data, from medium to hard.

Not a function, a visual. Turns a table into a picture: a bar chart, a line chart, or a pie chart, depending on what question the data is actually answering. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.

New to the function? Read the Charts guide first: syntax, a worked example and the mistakes people make.

In this set

  1. Compare sales across regions
  2. Track monthly active users
  3. Show each department's share of the budget
  4. Chart total hours logged by department
  5. Chart the revenue trend across quarters

The exercises

1. Compare sales across regions Medium

Each region logged more than one sale. Chart total sales by region so you can compare them at a glance.

AB
1RegionSales
2West320
3East210
4West300
5South150
6East90

Build the chart.

Show a hint

Each region appears more than once. Group by Region and Sum the Sales, then pick Bar chart to compare totals across categories.

Comparing a total across a handful of categories (regions, products, reps) is exactly what a bar chart is for. A line chart would wrongly imply these regions form a sequence.

2. Track monthly active users Medium

Product logged active users for each of the last six months. Chart how that number has moved over time.

AB
1MonthUsers
2Jan1200
3Feb1350
4Mar1290
5Apr1480
6May1600
7Jun1750

Build the chart.

Show a hint

This is one value per month, already in order. A Line chart is how you show a trend moving through time, not a Bar chart.

A metric tracked over consecutive time periods belongs on a line chart so the trend (up, down, flat) is the first thing you see, not a row of disconnected bars.

3. Show each department's share of the budget Medium

This year's budget splits across four departments. Chart each department's share of the total.

AB
1CategoryAmount
2Marketing4000
3Engineering9000
4Sales3000
5Support2000

Build the chart.

Show a hint

These four categories add up to the whole budget. A Pie chart shows what share each one takes, not how they compare side by side.

A pie chart only makes sense when the pieces add up to one meaningful whole, like a budget split across departments. Reaching for it for anything else, like a trend over time, is a classic charting mistake.

4. Chart total hours logged by department Hard

A timesheet export lists hours by employee, including a shift correction for two people who logged hours twice. Employee isn't what you're comparing. Chart total hours by department.

ABC
1EmployeeDepartmentHours Logged
2MayaEngineering38
3OwenSales22
4PriyaEngineering40
5LucasSupport15
6MayaEngineering10
7OwenSales18

Build the chart.

Show a hint

Employee is noise here. Group by Department (not Employee), sum Hours Logged for each, and use a Bar chart to compare departments.

Real exports are logged at a finer grain (per employee, per entry) than the summary you actually need. Recognizing which column to group by, and which to ignore, is most of building the right chart.

5. Chart the revenue trend across quarters Hard

Finance tracks revenue by product and quarter. Product isn't the question here. Chart total revenue by quarter to see the trend across the year.

ABC
1ProductQuarterRevenue
2WidgetProQ112000
3GadgetMaxQ18000
4WidgetProQ215000
5GadgetMaxQ29000
6WidgetProQ313000
7GadgetMaxQ311000
8WidgetProQ417000
9GadgetMaxQ414000

Build the chart.

Show a hint

Two products each report separately per quarter. Group by Quarter (summing across both products), then use a Line chart since this is a trend across consecutive time periods.

Combining rows across an irrelevant grouping (here, Product) before charting is common. The trend only becomes visible once you've summed to the level that actually matters, quarter by quarter.

Solve these in a real grid

Type your formula, get graded instantly. Your first 10 exercises are free, no signup.

Start the Charts exercises →

More dashboarding practice

All Excel practice exercises · Excel test prep