Conditional formatting in a chart gives an analytic
view.Anybody can easy find the low performance (Red columns) and high performance (green column) on the graph. As in below as soon as Target SL% (on range F1) is being changed, columns color (red and green) is getting changed according to target.
Steps to use conditional formatting in a chart
1-Take two support column on C (for Red) and D (for Green)
2-Put =IF(B2<$F$1,B2,NA()) formula on column C
3-Put =IF(B2>=$F$1,B2,NA()) formula on column D
4-Fill down the formula till the end.
5-Select range A1:A11
6-Press Ctrl and select range C1:D11
7-Insert a Stacked column chart under 2D column chart
8- Change the Color for columns Red color for blue columns.
9-Green color for magenta columns (in above picture 8 May and 10 May)
10- Your chart is ready with conditional formatting.
Please download this excel file from below given link:
Tutorial video for Conditional formatting in a Chart
PK, Your style is superb, God Bless You with more energy to teach people like me. How to contact as one of your Youtube Video of Project Issue Tracker, I tried and working almost fine, I am not able to search Numeric Value in Search Box, Text Search is working fine. and Report Section some of Graph showing error and once I click Support menu of that graph, and run application, it showing perfectly, please guide me on my email sha_m2@yahoo.com
ReplyDelete