Forum Discussion
Excel Project Gantt Chart: Adding Milestone Diamond
Hello, I am trying to put a diamond shape in my excel project from: How to Make the BEST Gantt Chart in Excel (looks like Microsoft Project!) - YouTube On 9:21. Can someone please help me why this ...
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)
