Is it possible to change the bar colours to red, green or amber rather than two colours (blue/green) determined by the 'done%' column . I would like to maintain the length of the bars which is based on the difference between start and end dates. However the % done would be replaced with Red, Green or Amber. The colours(red,green or amber) would be reflected on the bars. Could you please assist. I'm assuming the CF formula would have to be changed?
This is really a continuation of your other thread here...
https://www.excelforum.com/excel-gen...the-dates.html
But seeing as that is almost a year old, and was marked as solved, starting this new thread is probably better
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
At what percentages should the red/green/amber cut in?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Cells in Column H would have the Letter R, G or A representing red, green and amber rather than %. If a cell in column H has the letter R for example then the bar should be red, if it has G then the bar should be green, if it has A then the Bar Should be amber. An additional condition can be added called C, which would stand for closed, the bar should be grey in this case. Apologies, hope this makes sense.
Last edited by chris1089; 07-15-2020 at 02:23 PM.
There are some articles on the Internet for changing colors for a bar chart "excel change color on a bar chart" then it seems like you need to get [moderator removed reference to commercial product]. May have some help there or not.
Last edited by 6StringJazzer; 07-15-2020 at 10:31 PM. Reason: moderator removed reference to commercial product
Please update your file so column H has the correct letters for the color.
VBA may be linked to the bar graphs, which i have little experience in. This is where i need assistance
Please do not post only to tell people to search the Internet. We are pretty sure people know how to do that. Also do not post promotions for commercial products here.Originally Posted by way2020
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks