Excel Bar Graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

corona91719 - 09 May 2006 19:27 GMT

I have two sets of data on a bar chart but want to differentiate between
the two by different colors. Is this possible? I have 5 sets of data. I
want 3 to have a blue bar and the remaining two to have a red one.

Thanks.

Signature

corona91719

Reply to this Message

Andy Pope - 10 May 2006 09:14 GMT

Hi,

You can change the fill colour for a series of bars by simply double
clicking a bar within the series. This will display the format dialog.
To change the colour of 1 bar within a series first select the series
and then double click the specific bar.

Cheers
Andy

> I have two sets of data on a bar chart but want to differentiate between
> the two by different colors. Is this possible? I have 5 sets of data. I
> want 3 to have a blue bar and the remaining two to have a red one.
>
> Thanks.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message