Gannt Chart Query

[Corleone]

Morning all
I have created a GANNT Chart using Excel , it will consists of a number of milestones, using the dates in column D to plot them
it will form part of a more detailed Dashboard.

I am using conditioning formatting to generate where the milestone is displayed

The powers that be would like it shown in a specific way so that all you can see are the Milestone diamonds with the activity names to the right of each milestone.

How would i be able to automate this so that the text box is linked to the milestone? (at the moment the only way i can do it is by manually putting a text box against each milestone diamond, which wont really work as it will not move if the milestone
date changes.

The activity description is in column C and the date is in column D , So basically i want to get it to plot the text from column C to the immediate right of the milestone diamond in the GANNT Chart area based on the date in column D

thanks

 

[thisoldman]

I tried but could not get a completely automated solution formulas and formatting with no text boxes. It can be done with VBA.

Milestone labels in C4:C13
Milestone date in D4:D13, date in January or February
Calendar dates in E3:BK3; January 1 – February 28, 2018; custom number format 'dd'. "January" in cell E2, "February" in cell AJ2; these two entries formatted 'Center Across Selection'.

Font: Calibri 10 pts
Calendar column widths: 2
Formula in E4, copied down and to the right:
=REPT(UNICHAR(9670)&$C4,E$3=$D4)

If I completely clear the two cells to the right of the cell where the diamond and the label appear, the display is fine. Anything, including the empty string, in those two right-hand cells overwrites the label. In the image below, I've cleared the cells H4:I4; the cells J5:K5 still contain formulas.

An alternative is a scatter or line chart.