In this video I’m reviewing different ways to summarize employee pay with quartiles and how you can do that with a scatter graph in Excel.
Knowing when to use a scatter chart vs. a bar chart can take some planning but is well worth it to get the results you want.
Scatter charts work great if you have various data points, such as each employee’s position in range. Organizing a scatter chart so we can review which dots are falling within each quartile, can make it even easier to visualize and convey any trends.
As an HR professional, you understand the importance of data-driven decision-making and charts like these are great ways to present data. This video is the 4th in a series all about calculating and then charting compensation data into quartiles. To follow along with the first few videos in this series, see the link here: [ Ссылка ]
For free resources, including free templates and cheat sheets, checkout our page right here: [ Ссылка ]
