How to assign a color a single specific item on a chart

[SilverTRader]

Starndard bar chart. They want our company to always be Yellow.
This is a industry standard.
Our colums (the bar) needs to be Yellow.
As new companies are added to the series, it might change locations in the order.
For now, the location is 9th.

Can use formula or use VBA. Can't seem to find a way using the Excel interface to do this.

 

[SilverTRader]

There is a highlighter option to create a highlight in Yellow.
However, the goal is to make a specific bar Yellow

 

[nuked]

Normally when you add a series (or a company), it would simply add it to the end of the existing series, and add a new colour. What are you doing differently which means that the order of the series are changing when you update the data?

 

[SilverTRader]

It is a weekly chart. Companies are sorted in Alpha order.
It's position in the series would remain the same unless a new competitor shows up that is before the letter H (about every 9 months or so, one comes or one goes away).

Interesting enough, people working in the competitor - each of them always use Yellow as thier company too.
I was hoping that there was a collection of the bars where the color attribute could be assigned.

Appreciate the Add to the end. So, does that join up visually?
For example, Graph A through H (less than my company). Graph My Company then graph Greater than My Company.
Seems like a roung-about-way to accomplish it.