I have a spreadsheet with the following

Column F, building name

Each row on the spreadsheet is a member of staffs name

In Column I, I have got the number 1 if the member of staff has been
trained. If not there is a 0.

I need a Chart to show the number of members of staff who are trained per
work area. In the chart/ graph the work area should be along the bottom row
X. The number of staff members will be in the Y column.

Please would you be able to give some assistance. When I try to create a
chart the information does not show and it appears to be cluttered. There are
91 members of staff on the spreadsheet.

Any help would be appreciated