Conditional formatting of charts

specky · Apr 17th, 2002, 08:35 AM

I'd like to be able to conditionally format the data series of a chart depending on the results - is this possible? If so, how?

I'm heavily involved in service level agreements and would like the colour of the data series to show either Red, Orange or Green depending on whether or not we meet our targets.

Any ideas?

Mark W. · Apr 17th, 2002, 08:45 AM

What Chart Type are you using? Can you provide some sample data along with a detailed explanation?

specky · Apr 17th, 2002, 09:55 AM

I'm just using a straightforward bar chart.
The type of conditions I'm using are as follows:

Percentage of Calls not Completed (for example)
>=15% then bar would be Red
Between 10-15% then bar would be Orange and
<=10% then bar would be Green

Hope this helps.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 08:35 AM	#1
specky New Member Join Date: Apr 2002 Posts: 4	I'd like to be able to conditionally format the data series of a chart depending on the results - is this possible? If so, how? I'm heavily involved in service level agreements and would like the colour of the data series to show either Red, Orange or Green depending on whether or not we meet our targets. Any ideas?

Apr 17th, 2002, 08:45 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	What Chart Type are you using? Can you provide some sample data along with a detailed explanation?

Apr 17th, 2002, 09:55 AM	#3
specky New Member Join Date: Apr 2002 Posts: 4	I'm just using a straightforward bar chart. The type of conditions I'm using are as follows: Percentage of Calls not Completed (for example) >=15% then bar would be Red Between 10-15% then bar would be Orange and <=10% then bar would be Green Hope this helps.