Project/Milestone Chart - Need Suggestions for Displaying Status

[AMSO]

I finally got my chart in Excel working the way I want it. Two of the major hurdles that I finally overcame were:

• Show the start and end dates for the entire project as well as each milestone (in the axis). The range displayed needs to change automatically based on which project is selected.
• Display a line indicating today's date.

Now, what I am trying to figure out how to accomplish is "How do I get my status' into the chart?" - Not started, Work In Progress, Completed, etc.,.

I personally thought the best way to do that would be to utilize VBA code to change the color of the bar based on the status in my status column. I could then easily make a legend at the bottom of my chart (manually) indicating what each color represented. I haven't found anything that seems to do what I am after.

As a last resort, I could simply concatenate the values from my status column into the title column. But, that would be quite boring.

Does anyone have any suggestions on how I can achieve what I am after? I am wanting to either 1.) Have the bar color change based on the status or 2.) Incorporate the actual status somewhere into the chart. I'm open to suggestions. I'm not open to re-creating this monstrosity from scratch! Yes, I know it's probably the worst thing you've ever seen!

I am attaching a copy of what I'm working with. I will apologize in advance for the use of dummy data and dates that don't make any sense!

NOTE: The purpose of this is to be used for creating a project status presentation for my leadership team. Hence the filename.

[Andy Pope]

Add an extra series for each planning stage. Use formula to control the value for each of the series with only the matching stage series having a value.
The new chart data is to the right of you current table.

I have also tweaked the worksheet change code so it does not select the chart everytime you enter values on the sheet.

[AMSO]

Awesome! Thank you for the suggestion and fix to the worksheet change. That was annoying me!