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.
I have attached a sample workbook. This is what I see in it:
What do you see when you open it?
The same thing. I don't understand why it isn't working for just the Gantt chart
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
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.
