Best chart to identify between grades and promotion rate

Hi there,

hope someone can help me with choosing the right chart to display the following

basically i have set of data with employees and their grades and average of promotion, i need a chart to show this and ideally i want the chart to highlight people mainly on the certain grade.

excel spreadsheet attached


Thanks

Sandy