Change color bar based on name?

[Jimic]

Hello to all!
I have a horizontal graphic chart showing Intel and AMD processors speeds. I was wondering if it is possible to tell Excel to apply a color to Intel processors bar and another to AMD ones?
Thanks a lot for any help.

http://www.mrexcel.com/forum/showthr...=1#post2001107

[Andy Pope]

Create 2 more series based on formula that provide either the value or #N/A

Set the overlap to 100 and format bars as required.

[Jimic]

Thank you very much Andy!
What do you mean by overlap?

[Andy Pope]

the chart is a clustered bar chart, so when the chart contains 3 series normally you would see the 3 bars next to each other. When certains bars have no value you would not see the bar but a gap would be left in each category.

To avoid this you set the series overlap to 100. Now the 3 series will occupy the same space within a category.

double click series and on the series option tab set the overlap to 100

[Jimic]

I see, very nice explanation.
I want to do another thing on that chart, should i open another topic to discuss it?
Thank you Andy.

[Andy Pope]

start a new thread, include a link to this thread if it's relevent