Thread: How do I change the color of some bars in an Excel bar graph?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default How do I change the color of some bars in an Excel bar graph?
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/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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


Reply With QuoteReply With Quote