Forum Discussion

NickSirTek's avatar
NickSirTek
Frequent Visitor
1 year ago

Pay Band Graph

Hello everyone, Hoping someone can help me because I am at standstill.   I need to create a stacked bar chart (or whatever chart will work) to display blocks of the pay band ranges and then plot t...
Need Help
ahadkarimi's avatar
ahadkarimi
Solution Specialist
1 year ago

Hi NickSirTek, give this a try, and if you encounter any issues, let me know.

 

Create Stacked Bar Chart:

X-axis-> Pay Band
Y-axis-> Range


Overlay Employee Data:

Use a Scatter Chart

X-axis-> Pay Band
Y-axis-> Employee Salary

Show data labels for employee names.

 

Adjust colors and labels for clarity.

 

Did I answer your question? If so, please mark my post as the solution! ✔️
Your Kudos are much appreciated! Proud to be a Solution Supplier!

  • NickSirTek's avatar
    NickSirTek
    Frequent Visitor
    1 year ago

    This worked thank you, the only issue i have is with a slicer..since I did 2 different charts and overlayed them...the plot chart is showing the salary points in different spots as I slice by department. the department slicer works its just the plots are off...if I dont use the slicer all show correctly. I can provide screenshots but any idea?