Gespierde velopompe
New Member
- Joined
- May 20, 2010
- Messages
- 45
Good evening all,
Will try my luck again on the forum.
I'm working with some graphs and on a weekly or monthly bases the color of the bars needs to be changed according to the result of that certain week/month.
As this is a lot of work I'd like to write a macro for it. If I click on the button, the macro should work as follows:
1. Check the value of that certain week/month and compare it with the target that should have been reached in that week/month.
ex. result week 1 = 6
target week 1 = 7
2. Once the comparison has been made, it should adopt the color of that the bar based on the result of the comparison.
ex. the target of week 1 wasn't reached as the target was 7. So in this case the bar should be colored red.
I need some help from you guys on this one.
Thanks in advance
Will try my luck again on the forum.
I'm working with some graphs and on a weekly or monthly bases the color of the bars needs to be changed according to the result of that certain week/month.
As this is a lot of work I'd like to write a macro for it. If I click on the button, the macro should work as follows:
1. Check the value of that certain week/month and compare it with the target that should have been reached in that week/month.
ex. result week 1 = 6
target week 1 = 7
2. Once the comparison has been made, it should adopt the color of that the bar based on the result of the comparison.
ex. the target of week 1 wasn't reached as the target was 7. So in this case the bar should be colored red.
I need some help from you guys on this one.
Thanks in advance