Wage Charting

  • Thread starter Thread starter Jenni
  • Start date Start date
J

Jenni

I have a spreadsheet that lists employee names in one
column and their wages in another. Now, I would like to
make a chart, using that data, to chart how many people
make 8 to 9 dollars an hour, 9 to 10 dollars an hour and
so on. Any Ideas?
 
You could build a pivot table from the data, with Wages in the
row area, and Name in the data area, where it will become Count of Name.

In the pivot table, right-click on the Wages button
Choose Group and Show Detail>Group
For Starting at, enter your lowest amount, e.g. 8.
For Ending at, enter a maximum amount, e.g. 20
Leave the By setting at 1
Click OK

There are instructions and links for pivot tables here:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
 
Back
Top