I'm not sure if I understand your question correctly, but as far as I remember you can change bar colors in Excel. Check this out: http://office.microsoft.com/en-us/excel-help/vary-the-colors-of-same-series-data-markers-in-a-chart-HP010007429.aspx
This is the case: you have a class (males and females). You want to show in a plot how are variable the grades in X subject and in the same time the ranking. I wish to obtain the effect of a bar plot and a boxplot together.
This is a stripplot, done in Stata, with superimposed boxplots. The stripplot command, written by Nick Cox, will also superimpose means and confidence intervals (these can be calculated as normal, binomial or poisson). You can install it in Stata by typing