Excel - conditional formating on graphs. Change colour on a value

Dear Mr. Jon,

I had read your post and it is quite useful for me. However Now I need to make a chart with two X axes values. I had followed your procedure, however I can observe some gaps between the bars. Is there any way to remove the gap...I had used the Overlap option but its not working....

Herewith I had enclosed the screenshot for your reference.

Thanks in Advance

Regards
R. Vadivelan

Originally Posted by Jon Peltier

Conditional Charts:
http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Peter Shore" <Peter Shore@discussions.microsoft.com> wrote in message
news:5DA5CE6D-9234-4B47-AB8F-F3FB8E647110@microsoft.com...
> Excel - 2003 or previous.
> Conditional formating on cells is useful but I would like to see this on
> graphs as well.
> For example in a bar graph chart the series colour can be set either
> automatically or manually. A single data point can be set manually to a
> different colour.
> I would like to change a data point bar by condition / comparing to a
> value.
> The application is to 'flag' a data point by colour change if the value
> exceeds a certain comparison value.
>