Excel for HR: Salary Structure Floating Bar Chart

[@user-92-xckenv]

That's so useful! Many thanks to you 👏

[@shirleyrawson9200]

This helped me so much!! Thank you.

[@floalas]

Thanks Rachel this is so good. Can I draw a current salary structure vs new salary structure next to each Job Grade? Thank you.

[@fannybrisker5797]

Such a helpful video!

[@skjamilahmed]

Simply wow! Keep posting...

[@hibbasyeda8261]

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 :)

[@CariprosHRAnalytics]

Good tip!

[@kaityl.5771]

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

[@carolo274]

This is amazing but unable to do it :(

[@jamalcheema1573]

Awesome

[@carolo274]

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

[@manjumeena4253]

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

[@CariprosHRAnalytics]

well technically I think it's possible to do, but I never present multiple functions/ranges in the same chart because it would make the chart too complicated for the audience to understand. I can do a video presenting 2 ranges if u are interested. stay tuned then.

[@daphnequimada529]

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

[@CariprosHRAnalytics]

Hi Daphne, not sure what you mean?

[@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?

[@nhungbui1832]

you can see the red caption on the right top corner at 1:44 for the explanation why. FYI.

[@rohitr.p2777]

Nice

[@bankpig]

Wow! This is helpful🎉 Thanks.