These charts are geared to small banks or credit unions that want to have an informative visual of department salaries and/or bonus. It can be used on larger institutions as well, but I suppose the larger financial institutions have access to HR software that can provide graphics. I must give credit for the graph I saw on Chandoo.org. It gave me the idea to adapt his chart to a financial institution’s departments.
This example institution has ten departments. Each dot represents the salary/bonus of an employee, his/her department, and pay level or bonus level.
The data under the chart is not part of the chart and must be aligned with the chart.
Cell B4 on the charts is a single cell that is used to align the paygrades or bonus levels to the minor ticks. It is linked to each cell on row twenty-eight.
I included a third chart and instructions on how to add more departments and employees.
The employee numbers are just to keep track of all employees and are not used in the charts.