Forum Discussion
Excel Project Gantt Chart: Adding Milestone Diamond
I have received the workbook. The problem was not in the character, but in the formula.
The formula in J6 should be
=IF(J$4=$E6-WEEKDAY($E6,13)+7,"u","")
with the font set to Wingdings. Fill to the right and down. See the attached version.
The same thing. I don't understand why it isn't working for just the Gantt chart
I have received the workbook. The problem was not in the character, but in the formula.
The formula in J6 should be
=IF(J$4=$E6-WEEKDAY($E6,13)+7,"u","")
with the font set to Wingdings. Fill to the right and down. See the attached version.
- Thank you soo much!
A different approach. This formula spills from cell J6 and generates a couple of unicode characters.
= IF(FLOOR(timeline - taskStart, 7), "", start) & IF(FLOOR(timeline - taskEnds, 7), "", milestone)
I am also struggling with getting milestones on my chart and I can't seem to figure out what isn't working. Would you be able to help me ? HansVogelaar
I have replied to your private message.
Can you help with mine please? I have copied your formula as well as others but it still wont work.
Thank you
