Select different colors for each column in the graph

[yobi4ever]

Hi,
I would like to select my own color for each or multiple columns in the graph, how can I do this?

Fo value sin the x-axis between 1 -40 I would like to select all columns to be green, then 41-50 I would like to select all columsn to be orange...etc

Thank you.

[Claymation]

This is possible to do. In my version of Excel (2003) I just do a few slow clicks with the mouse (left button) and it will then select just the one column. Once the column is selected, right click and go to Selected Object and then to the patterns tab. You should then be able to change the color.

Just follow those steps for each of the changes that you want to make.

Hope that helps.