Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Conditional formatting
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Conditional formatting
 |
Conditional formatting |
|
|
Thread Tools | Rate Thread |
04-04-2006, 02:01 PM
|
#1 |
|
Guest
Posts: n/a
|
Conditional formatting
I've followed the correspondence on conditional formatting on charts with interest but is it possible to conditionally format a line chart i.e. green above a certain value, red below that value? -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.ph...fo&userid=25096 View this thread: http://www.excelforum.com/showthrea...threadid=529599 |
|
|
04-04-2006, 02:49 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: Conditional formatting
Hi,
Yes it's possible. http://www.andypope.info/charts/conditionalline.htm Cheers Andy Brisbane Rob wrote: > I've followed the correspondence on conditional formatting on charts > with interest but is it possible to conditionally format a line chart > i.e. green above a certain value, red below that value? > > -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
|
|
04-04-2006, 04:51 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: Conditional formatting
Is there a Vb solution to conditioinal formattin -- Eric_ ----------------------------------------------------------------------- Eric_B's Profile: http://www.excelforum.com/member.ph...nfo&userid=2448 View this thread: http://www.excelforum.com/showthread.php?threadid=52959 |
|
|
|
04-04-2006, 05:48 PM
|
#4 |
|
Guest
Posts: n/a
|
Re: Conditional formatting
If it can be done manually, it can be done in VBA. However, VBA isn't magic:
most things that can't be done manually also can't be done in VBA. The nice thing about VBA is that it can automatically do many of the tedious, repetitive things that we all hate to do. Specifically, you could set up a VBA program which will conditionally format elements of the chart, but only to the extent that they could be done by hand. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Eric_B" <Eric_B.25qyln_1144166103.803@excelforum-nospam.com> wrote in message news:Eric_B.25qyln_1144166103.803@excelforum-nospam.com... > > Is there a Vb solution to conditioinal formatting > > -- > Eric_B |
|
|
|
05-04-2006, 08:11 PM
|
#5 |
|
Guest
Posts: n/a
|
Re: Conditional formatting
Once again, thanks Andy... -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.ph...fo&userid=25096 View this thread: http://www.excelforum.com/showthrea...threadid=529599 |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
