Bar graph in Excel - Different colors on bars - Ecel 2007

I am creating a bar graph from two columns on an Excel spreadsheet.  All of the bars are the same color.  How do I create a bar graph with different colors?
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

right-click the bar series, select "Format Data Series" > Fill > Vary colors by point.

See attached.

Mind you that a bar chart with one series does not need different colors for the bars. In fact, it's rather counter-productive. The bar LENGTH is the message, not the bar color.

cheers, teylyn
Book1.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.