Coding / Programming Videos

Post your favorite coding videos and share them with others!

Excel for HR: Market Benchmark Pay Report with Floating Bar Chart (Part 1)

Download Video link >

Excel for HR: Market Benchmark Pay Report with Floating Bar Chart (Part 1)

Topic: Benchmark with Market Pay for Multiple Jobs (Part 1)
Chart Type: Clustered Column Chart
Business Scenario: You need to decide whether to increase pay level for a job (Business is complaining!).

You have the market data for 2 jobs and you want to visualize them for yourself and your clients.

In the next video, I will show you how to compare the market pay to internal employee pay and visualize them.

******Follow-up Consulting Services******
If you have specific question regarding your issue, you can email me at the email here Note that there will be a fee of US$50 charged for solving your issue. The turnaround is within 24 hours. Any follow-up issue in 3 days will also be answered with no charge. Payment link:

******More Videos in Playlists******
Excel for HR
Excel for HR – Master Class
Excel Macro – Beginner
Excel Macro/VBA – Splitting a Master File
Excel Charts Data Visualization
Excel Vlookup Function
Excel Pivot Table Function
Excel Array Function
Excel Index and Match Function
Excel Solver/Goal Seek Functions
Excel Cell Formatting Solutions
HR Analytics – Merit Matrix
HR Analytics – Salary Structure
Excel Tricks
Excel Troubleshooting
Fun HR Topics

For more successful stories, view at:

******Tools I use for this channel******
Channel management:
“I Love Spreadsheets” Mug:




View Comments source >

Transcript view all >

00:01 hello everyone today I want to show you

00:04 how to benchmark with market pay for

00:07 multiple jobs so the business scenario

00:10 is like this which is actually a typical

00:12 one so you are a HR manager and then a

Leave a Reply

Please Login to comment
Notify of
Translate »