PC Review


Reply
Thread Tools Rate Thread

Conditional formatting of line chart

 
 
Jack77
Guest
Posts: n/a
 
      12th May 2004
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!!


 
Reply With Quote
 
 
 
 
Debra Dalgleish
Guest
Posts: n/a
 
      12th May 2004
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

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:39 AM.