• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto update a chart color based on values

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.
 

Attachments

  • Sample_Sam.xlsm
    34.5 KB · Views: 6
Hi,

The short way is to add two more columns / employee with formula such as:

1. for score >=95%
=IF(score >= 0.95, score, NA())

2. for score <95%
=IF(score < 95%,score,NA())

than plot these values as two different series on the graph and color them as you required.

Regards,
 
Hi,

Thanks for your reply. My requirement is for first chart suppose value is >5 in column F then bar color should be change to Red automatically if less then 5 then green and suppose in column L & R value is >=95% then the bar chart color should automatically change to green if value is <=95 then should change to Red. I have lot of chart for every project so doing this manually so taking lot of time.

Would you please help me to do this automatically. Please do it in my sample_Sam work sheet attached and please send me the excel sheet.

Regards,
sangram
 

Attachments

  • Sample_Sam.xlsm
    34.5 KB · Views: 6
Sangram,

See the file, I had highlighted the extra column in yellow.

Regards,
 

Attachments

  • Sample_Sam (1).xlsm
    35.7 KB · Views: 18
Back
Top