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
- Compare sales across regions
- Track monthly active users
- Show each department's share of the budget
- Chart total hours logged by department
- Chart the revenue trend across quarters
The exercises
Each region logged more than one sale. Chart total sales by region so you can compare them at a glance.
| A | B | |
|---|---|---|
| 1 | Region | Sales |
| 2 | West | 320 |
| 3 | East | 210 |
| 4 | West | 300 |
| 5 | South | 150 |
| 6 | East | 90 |
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.
Product logged active users for each of the last six months. Chart how that number has moved over time.
| A | B | |
|---|---|---|
| 1 | Month | Users |
| 2 | Jan | 1200 |
| 3 | Feb | 1350 |
| 4 | Mar | 1290 |
| 5 | Apr | 1480 |
| 6 | May | 1600 |
| 7 | Jun | 1750 |
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.
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.
| A | B | C | |
|---|---|---|---|
| 1 | Employee | Department | Hours Logged |
| 2 | Maya | Engineering | 38 |
| 3 | Owen | Sales | 22 |
| 4 | Priya | Engineering | 40 |
| 5 | Lucas | Support | 15 |
| 6 | Maya | Engineering | 10 |
| 7 | Owen | Sales | 18 |
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.
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.
| A | B | C | |
|---|---|---|---|
| 1 | Product | Quarter | Revenue |
| 2 | WidgetPro | Q1 | 12000 |
| 3 | GadgetMax | Q1 | 8000 |
| 4 | WidgetPro | Q2 | 15000 |
| 5 | GadgetMax | Q2 | 9000 |
| 6 | WidgetPro | Q3 | 13000 |
| 7 | GadgetMax | Q3 | 11000 |
| 8 | WidgetPro | Q4 | 17000 |
| 9 | GadgetMax | Q4 | 14000 |
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 →