Excel for HR: Salary Structure Floating Bar Chart

New course Launched! I created it to show you step-by-step how to design a salary structure with regression analysis in Excel. Check out the detail here:
Chart Type: Clustered Column Chart 0:48

-~-~~-~~~-~~-~-
Please watch: "How to create a Merit Matrix for Salary Increase with Goal Seek function"
-~-~~-~~~-~~-~-

******Follow-up Consulting Services******

******More Videos in Playlists******

#ExcelforHR#HRAnalytics#Excel#HR

[-xckenv]

That's so useful! Many thanks to you 👏

[hibbasyeda]

side note if you can also choose fill as no fil option if u wish to see the grid lines, thank you for the video :)

[kaityl.]

Thanks so much for this! I do have one issue arising if you could help me figure out. I have about 100+ staff I want to use in the scatter plot. I follow the steps but the x axis just extends out too far and I don't know how to fix it. I hope I'm able to be clear on how

[carolo]

This is amazing but unable to do it :(

[daphnequimada]

Can you make a graphical representation of a salary scheme for a manager though? A yearly salary?

[carolo]

I’m unable to do this as the salaries comes after the ranges and doesn’t come on top:( not sure why !!

[manjumeena]

How would modify this to add all grade ranges for multiple functions in the same chart?

[tinkerFirst]

Hi you mentioned that the max value needs to be on top and your will explain why. I went through but you didn't mention why still. Do you mind sharing why?