PC Review


Reply
Thread Tools Rate Thread

Conditional formating in a Chart

 
 
Ola
Guest
Posts: n/a
 
      16th Apr 2004
Is there anyone who knows how to make conditional formating in a colum
chart. I want my positive observation to be blue and my negative red
Is this possible?

/Ol

--
Message posted from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
 
Andy Pope
Guest
Posts: n/a
 
      16th Apr 2004
Hi Ola,

Take a look at Jon's examples.
http://peltiertech.com/Excel/Charts/...html#CondChart

Cheers
Andy

Ola < wrote:

> Is there anyone who knows how to make conditional formating in a column
> chart. I want my positive observation to be blue and my negative red.
> Is this possible?
>
> /Ola
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
 
Reply With Quote
 
Nicky
Guest
Posts: n/a
 
      16th Apr 2004
I don't think you can have conditional formatting in the chart itself.

However, this code sets the interior color of all series to "3" (re
in the default colo scheme) if its value is below 0, otherwise to "5".


Sub change_cols()

For Each ss In ActiveChart.SeriesCollection
values_array = ss.Values
For n = 1 To ss.Points.Count
If values_array(n) < 0 Then ss.Points(n).Interior.ColorIndex =
Else ss.Points(n).Interior.ColorIndex = 5
Next
Next
End Su

--
Message posted from http://www.ExcelForum.com

 
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
conditional formating of a chart? =?Utf-8?B?Sm9obkE=?= Microsoft Excel Charting 5 29th Aug 2009 04:46 AM
Chart Labels - Conditional Formating Scott Microsoft Excel Charting 1 13th Sep 2008 10:03 AM
Conditional chart formating =?Utf-8?B?TWFyaw==?= Microsoft Excel Charting 1 31st Aug 2006 09:06 PM
Is it possible to apply conditional formating to a pivot chart? =?Utf-8?B?bGF5?= Microsoft Excel Charting 8 1st Apr 2006 11:37 PM
Road map with Chart Conditional Formating maxtre Microsoft Excel Charting 2 9th Aug 2005 08:52 AM


Features
 

Advertising
 

Newsgroups
 


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