Conditional formatting of line chart

's Computer Specifications

Hi,

Is it possible to change line chart so that when value is
>100 color of the line is green and when the value is <100
color of the line is red?

All help is highly appreciated!!

's Computer Specifications

Andy Pope has an example on his web site:

http://www.andypope.info/charts/conditionalline.htm

Jack77 wrote:
> Hi,
>
> Is it possible to change line chart so that when value is
>
>>100 color of the line is green and when the value is <100
>
> color of the line is red?
>
> All help is highly appreciated!!
>
>

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change line formatting in line chart - Excel 2007	LisaK	Microsoft Excel Charting	1	27th Aug 2009 11:09 AM
Conditional formatting in a bar chart	Charles Eaves	Microsoft Excel Charting	4	8th Nov 2008 05:06 PM
Chart Conditional Formatting	Jus	Microsoft Excel Misc	1	29th Aug 2006 08:14 PM
Conditional formatting in a chart	=?Utf-8?B?QmFybw==?=	Microsoft Excel Charting	3	27th Jun 2005 06:01 AM
Chart - conditional formatting	=?Utf-8?B?QWNoZXJvbg==?=	Microsoft Excel Programming	0	13th Oct 2004 04:09 PM