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 is not working? ↓
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.
It looks like the Wingdings font is not installed or damaged on your computer.
You can try the Symbol font, turn on Num Lock, and press Alt+0168 using the number keypad.
If you're willing to use a bullet instead of a diamond, set the font to the standard font of your worksheet (probably Calibri or Arial), turn on Num Lock, and press Alt+0149 using the number keypad.
- DavinAinebyonaCopper ContributorI have tried that but it doesn't seem to be working.
And I have tried it on multiple computers.I have attached a sample workbook. This is what I see in it:
What do you see when you open it?