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.


--
corona91719

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

corona91719 wrote:
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.



--

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