Different colors in bars of histogram with normal distribution curve

[jb]

Is it possible to have different colors in my bar chart with normal distribution curve?
I tried but "vary colors by point" option is not shown in fill option of format data series option of graph in excel 2007.
I do not want to paint manually by selecting each bar.

This option is available if I draw single series bar chart to have different colors for different bars.

 

[Hui]

As you have found out the Color by Point option isn't available when using multiple series or combination charts

The technique I described in your other post with the Up/Down arrows followed by the Left/Right arrow works fine