Charts and Dashboards: practice exercises
Choose the right chart and build it. These exercises cover column, line, pie, doughnut, scatter and combo charts, explain when each one fits the data, and finish with a small KPI dashboard that combines several charts and key figures. You create the chart in the practice sheet and the checker verifies its type, source range and series. A short way to move from a table of numbers to a picture people understand at a glance.
26 exercises · level: Confident User
Start with the first task Study the course: Charts and Dashboards →
Showing 26 of 26
Charts
Build a column chart of revenue by month (A1:B7).
Build a line chart of revenue and expenses together (A1:C7).
Show the structure of expenses as a pie chart (E1:F5).
Build a combo chart from A1:C7: revenue as columns, orders as a line.
Show the relationship between advertising and sales with a scatter chart from E1:F9.
In F11, calculate the correlation coefficient between advertising and sales.
Build a stacked column chart of the channels by quarter (H1:K5).
In B10:B12, calculate the yearly revenue of each channel: Store is column I, Website is J, Marketplace is K.
Show the shares of the channels as a doughnut chart from A9:B12.
On the "Profit" sheet, build a waterfall chart from A1:B7.
Check the bridge: in C7, calculate revenue minus all the costs. It should match B7.
On the "Products" sheet, build a bubble chart from A1:D6: price, sales per day, and margin as the bubble size.
On the "Cities" sheet, add line sparklines for B2:G5 in column H.
Build a column chart of coffee revenue by month (A1:B7).
Show the trend of coffee and pastries on one line chart (A1:C7).
The branch names are long, so compare visits with a bar chart (F1:G6).
Show the shares of the payment methods as a pie chart (I1:J5).
In D2:D7, calculate the "Total" revenue (coffee + pastries), then build a column chart of the whole table A1:D7.
Project P06
Make a dropdown list of months in F1, using H2:H7 as the source, and pick "March".
In F3, calculate the revenue for the month chosen in F1 and format the cell as currency.
In F4, count the deals for the month, and in F5 calculate the average deal (revenue / deals).
In F6, calculate the month's share of the half-year revenue and turn on the "%" format.
Fill in the monthly totals: revenue in I2:I7 and the number of deals in J2:J7.
In F9:F11, calculate the revenue of each city for the chosen month.
Build a combo chart from H1:J7: revenue as columns, deals as a line.
Build a doughnut chart from E8:F11 and switch the month in F1: the chart changes.
No exercises match these filters.