Excel for HR: Salary Structure Floating Bar Chart |
Video transaction:
So today I'm going to show you based on a table that you're given or you want to create how do we create a chart where we have all the job levels at the bottom and then we showed mean mid and max for the pay range of each of the levels so the first thing you need to do is to create a table in this format and one thing agent note is that the max the row with the highest value needs to stay on the top and I will show you why and then next you select the data range where's the Hatters and go to recommended chart and the one that you want to select this clustered column chart so you go to okay it will give you a chart one thing I want to share with you is that you can move actually move the chart to a new sheet which makes it look bigger and nicer the next thing you want to do is to select any of those data series go to format and there on the right with data overlap bring everything to a hundred percent and this way you'll have all the three parts or overlapped into one you can also adjust the gap works with which can narrow the gap between your bars but it's not required so that's now you have all the bars the next thing you can do is to select the lowest one the minimum and then go to format go to fill and select white so you can see all the ones become white you might also notice that you would have the grid line here and doesn't look nice when you have the white part the trick here is to delete them therefore you can only have the floating chart here you can also change the color of the of your bars as you wish for example this one maybe I want to change to a light blue I can't do that and then you can add basically add a data label to all the two are the bars for the max for the MIT and for the mean yep and here we go so this is how a salary structure floating bar chart would it look like
Post a Comment