I want to show distribution of annual salaries (y axis) by position (x axis) across my company with an added layer showing where the average falls by location (secondary x axis). I've attached a sample picture but can't figure out what type of chart it is, let alone how to build it. I originally thought a simple column chart with an avg vertical line added but that's not worked. Any ideas?!? Bonus if you can draft up a sample in an excel template!
Thanks!!!
Bookmarks