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: https://www.youtube.com/watch?v=tuQpGzL_14g&t=2s On 9:21. Can someone please help me why this is not working? ↓
- 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.
DavinAinebyona
Mar 09, 2023Copper Contributor
The same thing. I don't understand why it isn't working for just the Gantt chart
HansVogelaar
Mar 09, 2023MVP
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.