If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Columns change colour with value
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 -- koootzz ------------------------------------------------------------------------ koootzz's Profile: http://www.excelforum.com/member.php...o&userid=30982 View this thread: http://www.excelforum.com/showthread...hreadid=506495 |
#2
|
|||
|
|||
Columns change colour with value
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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Quick Text colour change? | mrrix32 | General Discussion | 0 | January 11th, 2006 04:30 PM |
Change colour of bars/lines in charts when data in rows/columns | RodP | General Discussions | 1 | October 25th, 2005 03:51 AM |
how do I change the background colour of my Inbox? | Lori | General Discussion | 0 | January 13th, 2005 03:39 PM |
How to change the colour of the word program border | garfield-n-odie | General Discussion | 0 | November 21st, 2004 04:26 AM |
change the font colour in a validated drop-down list? | Annette | General Discussion | 1 | October 29th, 2004 11:49 AM |