Skip to main content

Total deposits and build a column chart

100%
SUM

A chart should use a number that has already been checked. Here, each region has savings, current-account and fixed deposits. SUM combines those three figures into a total before the chart is made.

A column chart compares separate regions by the height of their totals. The source workbook also asked for a 3D pie chart; this exercise uses the browser engine's column chart, which is a clearer match for comparing regions.

Calculate Total Deposit in B2:B5 and the overall total in B6, then use the Chart tool to create a column chart from A1:B5.

The grid for this exercise is part of the paid half.

Everything above is yours to read either way. 46 exercises stay free with a profile.

Adapted from Excel Beginners Practice Lab by Muhammad Auwal Abdulaziz (MIT).