Salary Range before & after Median

Welcome to the forum

In the first part of your question you ask for: "Charts to show Salary Ranges with a Median line as center point, which shows data after / before Median line."

From your "Workings" worksheet I have created a Pivot Chart sourced from your "Workings" worksheet that looks like this:

eathan_boss20gamer.png

The chart as depicted above shows CTC (salary) as blue bars for all employees that are grade M5 with a role of "Senior Developer". The median for that group is the red line. The filters allow you to quickly select and chart a different set of grades and roles and designations.

An update to your workbook is attached.

Hopefully this is of some use - I wasn't really clear on the rest of your request.

Per my response to your PM, the usual reason for lack of responses is unclear requirements - especially if the requirements are complex. Few people will want expend significant effort on a guess at a solution if there is a high probability that it won't meet your real need.

Here's some questions, the answers to which might help you to clarify your requirements.

1. How many charts are you expecting to develop? - are you expecting everything you ask for to fit on a single chart or will there be multiple charts? If the latter then describe each chart separately.
2. For each chart, what specific worksheet & column maps to the x-axis?
3. For each chart, what specific worksheet & column(s) are to be plotted on the y-axis?
4. Do the columns to be charted all exist or do you expect additional columns to be computed, if so what are they and how are they calculated?
5. You have grabbed a couple of charts from the Web, one looks like a horizontal stacked bar, the other looks like a waterfall chart - which do you want?
6. Can you provide a specific mapping from all of the data depicted on your chosen chart to your specific data columns?
7. Alternatively, can you, in some drawing program, sketch exactly what you have in mind and annotate the sketch with the exact mapping your specific data columns.
8. Can you think of a simpler subset of your requirements that would represent a first step towards what you ultimately want - something that could then be built on step by step? That way you could at least show some progress in the short term.

Finally - when you provide column references then make sure they are accurate! For example in your original post #1 you reference Columns E to M - I think it should be E to L, also you reference Columns M to N - I think it should be M to T.

In summary, hopefully, if you can clarify your needs further or if you can specify a simpler first step, then you may attract the interest of someone with more in-depth charting knowledge than I can bring to bear.

I hope this helps.

You said:
In simple, my leaders want to see Salary range of all employees at each Role, Grade and their percentile position in a chart with a ideal median as a line (where they can see how many employees are above & below ideal median), beyond this I don't know how to explain.

Here's the best I can do: It's another pivot chart.

eathan_boss20gamer_1.png

The orange bars show the salary range for all employees for each role. You can filter on grade to see the specific salary ranges for one or more grades.
The red bars are the "Ideal median" taken from Workings!I:I. I needed to add a new column to Workings!J:J called "MaxMinusMin" in order to construct the chart.