Results 1 to 3 of 3

Comparing rises in salaries

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,959

    Comparing rises in salaries

    I am very unskilled in charting and have to present a view of how Admin salaries have not kept up with Client or Direct Delivery salaries for a few years. Within each of these broad categories are smaller programs.

    Since salaries can vary wildly between the differnt programs (floor sweepers make much less than nuclear physicists) I don't want to chart just the bare salaries, but thought instead to chart the rise percentage.

    So, I've done calculations of the average salaries by year, and the average percentage rise in salaries,putting zero for where the average salary lowered (for instance, if a 20 year veteran making $70K per year retired, and a new guy making $40K came in, the average goes down, especially if there are few FTEs in that program).

    So, I have the data, but am at a loss as to how to present it to a nonTechnical supervisor, and how to arrange the data to chart it.

    I've attached my data and hope someone can help me get started. Thanks in advance for any help.
    Attached Files Attached Files
    Last edited by jomili; 01-13-2023 at 12:01 PM. Reason: Forgot to attach
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Identify continues rises in Excel
    By igors16 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-29-2022, 03:58 AM
  2. detecting steep rises and drops of data
    By elvalo in forum Excel General
    Replies: 12
    Last Post: 06-28-2022, 05:16 PM
  3. [SOLVED] Rank Pay Rises for Person by Date
    By watchouse in forum Excel General
    Replies: 10
    Last Post: 03-26-2018, 08:37 AM
  4. Sell stock when it rises 5% and close when it falls 5%
    By tsakta13ole in forum Excel General
    Replies: 22
    Last Post: 03-01-2016, 06:11 PM
  5. [SOLVED] Comparing Male and female salaries based on Performance and gender
    By CA_needing_help in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-19-2014, 09:46 PM
  6. Replies: 6
    Last Post: 11-20-2009, 09:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1