I am having a difficult time trying to change the color of the bar graph based off the status that chosen. I've been looking at blogs and found that this can possibly be done with a vba code but I am stuck on how to do so. Is there a way a vba code can be created to have the color of the bar change if the status is changed? I have attached an example of the workbook that I am working with.
It took a lot of trial-and-error fumbling around, but I think this will work for you. In the VBA window, in the Project Explorer treeview, double-click Sheet1 (Project Timeline) to open the sheet code window, and copy and paste in the following.
Please Login or Register to view this content.
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
OMG thanks so much! It worked perfectly! Do you know if I can have the activities that do not have a status not have a color at all and just let the in progress/pending and completed status be the only one that does?
The following works if you blank out an existing status, but I'm not sure if it will work when you're creating a new milestone because I don't know what your procedure is for doing that. It may initially appear with the default colors. You'll just have to try it and see. The code I added simulates going into the series format and changing the Marker Fill to No Fill or Solid Fill, and the Line Color to No Line or Solid Line.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks