How to Graph Salary Ranges of Bands

Written by francine richards
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Graph Salary Ranges of Bands
Utilising a graph to view salary bands is useful when categorising positions. (pastel colour graph image by Tomislav from Fotolia.com)

Many companies categorise 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.

Skill level:
Moderate

Other People Are Reading

Things you need

  • Microsoft Excel
  • List of salary bands and ranges

Show MoreHide

Instructions

  1. 1

    Open Microsoft Excel and click “File”, “New” and “Blank Workbook” to open a new document. The blank document will display, ready for usage.

  2. 2

    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.

  3. 3

    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.

  4. 4

    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.

  5. 5

    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.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.