Chart & Visualization Issues

Add a Diamond Milestone Marker to an Excel Gantt Chart

Huda QurayshiHuda Qurayshi Nov 18, 2026 869 views

Question details

Add a diamond milestone marker to an Excel Gantt chart using a formula and a symbol font.

Add a Diamond Milestone Marker to an Excel Gantt Chart
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet-based Gantt chart has milestone dates in column E and weekly timeline headers starting in column J.
Observed behavior
The user wants a diamond to appear in the timeline cell for the week containing each milestone date.
Before you start

Check that E6 contains a valid milestone date and J4 contains a valid weekly timeline date. The formula matches the Tuesday ending the week containing the milestone, so the timeline headers must use those week-ending dates.

Solution 1Recommended

Use a Formula and Wingdings to Show Milestone Diamonds

Use this method to automatically place a diamond in the matching week for each milestone.

1
Enter the milestone formula

Select cell J6 and enter =IF(J$4=$E6-WEEKDAY($E6,13)+7,"u",""). Press Enter.

2
Fill the timeline

Select J6 and drag its fill handle right across the timeline, then down through the milestone rows. Adjust the cell references first if your dates or headers are in different locations.

3
Apply the symbol font

Select the formula cells, then choose Home > Font and select Wingdings. The formula's lowercase u should display as a diamond.

Use a Formula and Wingdings to Show Milestone Diamonds
If Wingdings is unavailable: Check whether Wingdings is installed on your device. If you cannot use it, replace "u" in the formula with a bullet character and apply a standard font such as Calibri or Arial.
WPS Spreadsheets

Add Milestone Diamonds in WPS Spreadsheets

Open your Gantt chart in WPS Spreadsheets, use the same date-matching formula, and apply Wingdings to display milestone diamonds.

  1. 1. Open the workbook: In WPS Spreadsheets, choose Open and select your Excel Gantt chart workbook.
  2. 2. Enter the formula: Select J6 and enter =IF(J$4=$E6-WEEKDAY($E6,13)+7,"u",""). Adjust the references if your worksheet uses different cells.
  3. 3. Fill the formula: Drag the fill handle across the weekly timeline and down through the milestone rows.
  4. 4. Format the markers: Select the formula cells and choose Wingdings from the Home tab's font list. Save the workbook using File > Save.
Automatically mark milestone weeks in a Gantt timelineOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and font controls
microsoft office alternative - wps office

Frequently Asked Questions

Why does the formula show a letter instead of a diamond?

The formula returns a lowercase u. Select the result cells and choose Wingdings from Home > Font to display it as a diamond.

Which date should appear in the timeline header?

With WEEKDAY(E6,13), the formula calculates the Tuesday ending the week containing the date in E6. The corresponding timeline header must contain that date as a valid spreadsheet date.

What can I use if Wingdings is not installed?

Check whether Wingdings is available on your device. Alternatively, replace "u" in the formula with a bullet character and select a standard font such as Calibri or Arial.

Why does no marker appear for my milestone?

Check that the milestone and timeline headers are valid dates and that a header matches the calculated week-ending Tuesday. Also check the formula references if your milestone dates or timeline start in different cells.