ExcelBanter - Excel Bar Graph

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Excel Bar Graph (https://www.excelbanter.com/new-users-excel/87744-excel-bar-graph.html)

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