Excel For TR Professionals - Building Floating Bar Charts for Salary Ranges in Excel

TRPDX Excel Workshop #4: Building Floating Bar Charts for Salary Ranges in Excel

Date: December 18, 2025

Time: 9:00 – 10:30 AM

Location: Virtual (Zoom)

Understanding how to clearly visualize salary ranges is essential for communicating compensation structures to leaders, HR partners, and employees. In this focused, hands-on course, participants will learn how to build floating bar charts in Excel — a powerful and underused visual that allows you to display min/mid/max, job-level progressions, and compa-ratio positioning with clarity and impact.

This session is designed for Total Rewards and Compensation professionals who want to transform raw salary range data into visuals that tell a clean, intuitive story.

What You’ll Learn

✔ How floating bar charts work and why they’re ideal for salary range storytelling

✔ Structuring your data (min, mid, max, and employee pay) for chart-ready formatting

✔ Techniques for building the floating bars

✔ Adding markers for compa-ratio or individual position-in-range

✔ Formatting tips to make your chart presentation ready

✔ How to use floating bars to support conversations about pay progression, equity, and compression

Who Should Attend

This course is ideal for:

• Compensation Analysts & Managers

• Total Rewards Professionals

• HR Business Partners looking to deepen comp skills

• Anyone involved in range design, salary structure communication, or merit planning visuals