Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi, today I watched a webcast for easy charts on excel, in there it was
mentioned that you can use formulas to change the color of a data label customizing the numbers, my question is: How can I use it to define for a section? (I need to get red colored for values upper than 10%, yellow for values between 10 and 8%, and normal for below) I tryied based on my experince to use the following formulas: [red][0.1]0%;[yellow][<0.1 and 0.08]0%;[black]0% but doesn't work Tha actual formula i'm using is the following: [red][0.1]0%;[black]0% I don't want to use macros, this is just to learn the way to do it different. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Formats | Excel Discussion (Misc queries) | |||
Custom Formats | Excel Discussion (Misc queries) | |||
number formats that allow you to format the appearance of negativ. | Charts and Charting in Excel | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) |