Have multiple colours on a single bar on a chart in excel

[Sriram Iyengar]

Guys,

How do I change the colour of a single bar on excel. I need the part greater than 100% to show in Red



Post Moved by Mod

 

[NARAYANK991]

Hi ,

Such a brief description of your problem is not likely to get you immediate answers , and correct answers at that.

Upload a sample workbook with enough data , and the chart in question , and you are more likely to get a more appropriate answer.

Narayan

 

[Sriram Iyengar]

Thanks Narayan,

If you look at the Charts worksheet there are people who are crossing 100% utilization. I want the >100% section to be in a different colour

 

[NARAYANK991]

Hi Sriram ,

See if this is OK. I have done it for only one chart ; you will have to do the same for all the other charts or as applicable.

Narayan

 

[Khalid NGO]

Hi,

I have used 2 helper columns in Task Wise % Split sheet.

1 in column C, and 1 in column N, and then added one more series in both charts at Secondary Axis.

1st Chart:
Bars will be turned to red, if the values are >=100.

2nd Chart:
Used a different way to highlight the maximum value only (you can use chart 1 technique if it is not required).

See if it helps.

Regards,

Edit: Narayan Sir was fast, beat me by less than a minute