How to change the color of a bar graph in excel?

by Manshu on August 17, 2010

in Personal Technology

Someone asked me how to change the color of a bar graph in an Excel sheet, and I thought I’d write a quick post about it since it is a fairly straightforward thing to do.

Say you have a bar graph which displays two parameters – Good and Evil, and Excel throws up a graph like this:

image

Now say you want to change the color of these two bars to green and red. The guy who asked me about this was right clicking on a bar, and then selecting a color from the “Shape Fill”. The trouble was that it was coloring both the bars like this.

image

Instead of this – double click one bar, and it will open up the “Format Data Point” dialog. Next select “Fill”, and then “Solid Fill”. Select the color you want from there, and it will only color the bar you have selected.

image

It just takes a few seconds, once you know it, but knowing it sometimes takes a few hits and misses.

Views: 11548


Get free daily updates in your email:






{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post: