sangramkesharijena
New Member
Hi,
I am preparing a weekly report that measures the employee performance.
The bar color should be Red -If value is <=94.99% score, Green If >=95%).
Is there any way, using VBA or a macro, to change the color of a bar (data point) automatically based on the value. Can it run through all of the data points in each chart and make the changes based on criteria.
Thanks in advance for any tips or help that you can give me.
I have attached a sample work book. Please help.
I am preparing a weekly report that measures the employee performance.
The bar color should be Red -If value is <=94.99% score, Green If >=95%).
Is there any way, using VBA or a macro, to change the color of a bar (data point) automatically based on the value. Can it run through all of the data points in each chart and make the changes based on criteria.
Thanks in advance for any tips or help that you can give me.
I have attached a sample work book. Please help.