I would like to create some basic shapes using excel VBA based on the below mentioned sample data in excel. If both start and finish dates are available then I want to add a line to the scale under respective month or months. e.g. if the start and finish dates are 08-Jan-2017 and 14-Jan-2017 then I want a line to be drawn to the scale under Jan-2017. If there's only either a start or finish date available then I want to add a diamond shape to the scale under the respective month. Please help me to solve this. Thank you so much!

Capture.JPG