Advanced Combination Chart Help

[CzechCzar]

Hi all


My manager has asked me to make a pretty complex chart. Apologies for the crappy handwriting, but the drawing is necessary.

I work in HR, and we are dealing with mapping employee's salaries to market salary surveys. My manager wants a floating bar representing the 25th %ile, 50th %ile, 75th %ile, and average, of the survey position. I need the same for internal position to which the survey position matches - for these I want the maximum, mean, median, and minimum, again displayed as a floating bar. (Internal employees are called incumbents.)


Survey data is not given on an individual basis, but only aggregated in 25th %ile, 50th %ile, 75th %ile, and average. Internal incumbent data is individual, obviously, and I calculate these statistics myself.


Further down the rabbit hole: next to these floating bars, I need to display the individual employee (incumbent) data, in scatterplot form. And, I need to be able to separate the data, by gender, by age, etc.


I have no idea how to get this to work properly in Excel. Is this even possible?

 

[Jon Peltier]

Try again. The protocol I wrote up was done in 2013. In any case, it differs only slightly from that for 2010 and 2007, and the differences are mostly in where to find a given button in the ribbon.