Many companies categorize employee salaries into bands. Each band represents a range of salaries including a minimum, median and maximum amount. Each position at the company falls into one of the bands. Position level and geographical location of the job are often ways to classify each band. The band structure gives employers a guideline for hiring new employers and provides order and a logical flow for salary increases. Creating an easy-to-read graph of salary ranges of bands is useful for Human Resources, hiring managers and executive leadership. Creating graphs is easy within a few steps in Microsoft Excel.
Things You'll Need
- Microsoft Excel
- List of salary bands and ranges
Open Microsoft Excel and click “File”, “New” and “Blank Workbook” to open a new document. The blank document will display, ready for usage.
Set up table with a column called “Bands” to represent each of the salary bands. Set up three additional columns titled “Minimum,” “Median” and “Maximum” to represent the dollar value within each band.
Enter band names in the “Bands” column. You may want to use A1, A2, A3, B1, B2 etc. Enter corresponding dollar values representing the salary ranges for each band under the “Minimum,” “Median” and “Maximum” columns. Highlight the cells representing dollars and from the “Home” tab and the “Number” group, click the dollar sign icon to format the numbers as dollars.
Highlight the entire table, all columns and rows, with your mouse. Go to the “Insert” tab and the “Charts” group. Click the type of graph you wish to use for your salary ranges of bands such as “column” or “pie” and select the specific graph style.
Move your chart on the document so it does not overlap your data table by dragging the entire graph box with your mouse and dropping it where you wish on the worksheet. To move to a different worksheet, right click within the chart and click “Copy.” Click “Sheet 2” tab at the bottom of the window, right click in the new worksheet and select “Paste Options” and “Keep Source Formatting.” Reposition by dragging and dropping.