Forum Discussion
DavinAinebyona
Mar 01, 2023Copper Contributor
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 ...
- Mar 09, 2023
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.
HansVogelaar
MVP
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.
DavinAinebyona
Mar 10, 2023Copper Contributor
Thank you soo much!
- PeterBartholomew1Apr 16, 2024Silver Contributor
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)