Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Color Change in chart based of condition
Dear All
I have plotted a chart where there is a target value for the whole year and mothly actual values and their avg is plotted. Now I need to show the performance in green if year to date (YTD) value exceeds the target. If YTD is equal then I want to show it as yellow otherwise in green. I know this can be done on the data table with conditional formatting but how to do the same for the bar chart? I will appreciate reply from any genius out there who knows this. Thanks in advance for your inputs. Regards |
#2
|
|||
|
|||
Conditional Charting:
http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KRT wrote: Dear All I have plotted a chart where there is a target value for the whole year and mothly actual values and their avg is plotted. Now I need to show the performance in green if year to date (YTD) value exceeds the target. If YTD is equal then I want to show it as yellow otherwise in green. I know this can be done on the data table with conditional formatting but how to do the same for the bar chart? I will appreciate reply from any genius out there who knows this. Thanks in advance for your inputs. Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel |