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
|
|||
|
|||
Conditional Formating
Let me start by saying that I have also posted this on MR Excels forum, and recieved no replies. so... here goes. I am trying to conditionally format a Donut/Speedometer chart. ( I saw it on peltiertech.com) howver I need the actual Donut part to change colos, based on the value input for the needle. Green for A positive and Red for a negative. any ideas? Tempus -- Tempus ------------------------------------------------------------------------ Tempus's Profile: http://www.excelforum.com/member.php...o&userid=34381 View this thread: http://www.excelforum.com/showthread...hreadid=541603 |
#2
|
|||
|
|||
Conditional Formating
Hi,
You would need to have 2 values for each segment. The depending on the result of the condition the 1st set of each pair would be zero or the appropriate value whilst the 2nd pair would be the reverse. If this doesn't answer your question maybe you could explain a bit more about how the dial should change colour seeing as the dial has 3 colours. Cheers Andy Tempus wrote: Let me start by saying that I have also posted this on MR Excels forum, and recieved no replies. so... here goes. I am trying to conditionally format a Donut/Speedometer chart. ( I saw it on peltiertech.com) howver I need the actual Donut part to change colos, based on the value input for the needle. Green for A positive and Red for a negative. any ideas? Tempus -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
excel conditional formating decimal fractions | Andy Dixon | Worksheet Functions | 6 | April 17th, 2006 10:25 PM |
Conditional formating using formulas | arifnj | Worksheet Functions | 4 | October 27th, 2005 01:56 PM |
VLOOKUP & Conditional Formating Help. | Excel'ed Failures | General Discussion | 6 | August 16th, 2005 04:46 PM |
Conditional Formating in Report Header | Haas | Setting Up & Running Reports | 1 | July 21st, 2004 10:50 PM |
Conditional Formating | Brw | Worksheet Functions | 3 | December 9th, 2003 03:12 PM |