Progress Chart with X-Values as Target Completion Date

[Jnehra]

Hi All

I have created a simple progress bar in Excel. I need help in customizing the X-Axis so that the values show a few dates rather than numbers. I have attached my worksheet as a reference. I am being asked to show the date when we each phase will be completed. 'In Progress' will be completed November 7. At that time I'll update cell C2 to '15'. I'd like to add a marker or error bar or something to show the date November 7 at that spot. I'd also like to show another marker or error bar at the end of the chart with the date December 30. This is when the 'Not Started' phase is scheduled to complete. I hope I am being clear with what I am asking here and thank you for any help!