Columns change colour with value

's Computer Specifications

Is it possible to make the columns in a bar chart change colour once th
data goes above a certain value i.e. if the data is below target th
column will be red, above target the column will be green.
Thank

--
koootz
-----------------------------------------------------------------------
koootzz's Profile: http://www.excelforum.com/member.php...fo&userid=3098
View this thread: http://www.excelforum.com/showthread.php?threadid=50649

's Computer Specifications

Hi,

See Jon Peltier's example of conditional charts,
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

koootzz wrote:
> Is it possible to make the columns in a bar chart change colour once the
> data goes above a certain value i.e. if the data is below target the
> column will be red, above target the column will be green.
> Thanks
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I change my outlook 2003 colour to Any other colour?	Navneet	Microsoft Outlook	0	23rd Mar 2009 03:58 AM
Change cell colour on formula result change, no conditional format	roster_jon	Microsoft Excel Programming	0	2nd Dec 2008 01:11 PM
how to change the colour of task bar (bottom) and title bar (top) from black to any other colour	hash	Windows Vista Performance	1	5th Aug 2007 02:32 AM
change a cell background colour to my own RGB colour requirements	=?Utf-8?B?U3RlcGhlbiBEb3VnaHR5?=	Microsoft Excel Misc	4	16th Jun 2006 02:08 PM
Colour Grouping of Columns	WSF	Microsoft Excel Charting	1	20th Mar 2005 12:21 PM