Conditional Formatting on Bar Charts

**Paul Sheppard** · 05-07-2008, 05:44 AM

I am using excel 2000

Is it possible to use conditional formatting to show the bars as 3 colours, the average to be say blue, above average green and below average red, if yes how?

**Greg M** · 05-19-2008, 06:19 PM

Hi Paul,

I think the attached workbook should give you an idea of how to proceed.

Basically, you have to take your single series and automatically convert it into three separate series: one below-average, one average and one above-average. Each of these three series (appropriately colour-coded) can then be plotted on a single chart.

Hope this works, please let me know how you get on.

Regards,

Greg M

**Paul Sheppard** · 06-30-2008, 04:03 AM

Originally Posted by Greg M

Hi Paul,

I think the attached workbook should give you an idea of how to proceed.

Basically, you have to take your single series and automatically convert it into three separate series: one below-average, one average and one above-average. Each of these three series (appropriately colour-coded) can then be plotted on a single chart.

Hope this works, please let me know how you get on.

Regards,

Greg M

Hi Greg

Sorry for delay in replying, that's just what I need