How do I change the color of some bars in an Excel bar graph?

[fergusonlaura]

I have a big data series and want to manually assign three different colors
to the bars. Can this be done?

 

[Jon Peltier]

Click once to select the entire series, then click again to select one point
(one column). Then go to Format menu > Point, and apply a format to the
selected point only.

To do it automatically, you could set up a conditional chart:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

- Jon