'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Customize Gantt Chart Milestone Icons by Field in Microsoft Project
Question details
The user wants to display different levels of project milestones using distinct colors and shapes on a Gantt chart based on a custom Milestone Level field.
- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Visualizing different priority levels or phases in a project timeline by assigning specific milestone symbols to custom field values.
- Observed behavior
- The user needs the precise steps to configure Microsoft Project's Bar Styles so that customized milestone shapes and colors automatically map to custom field parameters.
Ensure your Microsoft Project file is open and that you have identified or created the custom Flag fields you will use to categorize your different milestone levels.
Use Custom Flag Fields and Format Bar Styles
This solution involves creating custom Flag fields to represent milestone levels, and then adding new bar style rules in the Gantt chart to apply specific colors and shapes to those flags.
Microsoft Project's 'Bar Styles' dialog does not allow formatting directly based on Text or Number fields. Instead, you must use 'Flag' fields (Yes/No). You can assign different flags to represent different milestone levels and set specific formatting rules for each flag.
Navigate to the 'Project' tab on the ribbon and click 'Custom Fields'. Select 'Flag' from the Type dropdown. Rename 'Flag1' to 'Level 1 Milestone' and 'Flag2' to 'Level 2 Milestone'.
In your task list, insert the new Flag columns. Set the corresponding Flag to 'Yes' for the milestone tasks you want to uniquely format (e.g., set Level 1 Milestone to Yes for primary milestones).
Right-click anywhere on the empty portion of the Gantt chart area and select 'Bar Styles' from the context menu.
Scroll down in the Bar Styles list and insert a new row. Name it 'Milestone Level 1'. In the 'Show For ... Tasks' column, type exactly 'Milestone, Flag1'.
With the new row selected, look at the bottom half of the dialog under the 'Bars' tab. In the 'Start' section, choose your desired Shape, Type, and Color for Level 1. Repeat steps 4 and 5 for 'Milestone Level 2' using 'Flag2'. Click 'OK' to apply.
Manage Projects Seamlessly with WPS Office
While Microsoft Project is a specialized tool with a steep learning curve, you can effortlessly create, manage, and customize Gantt charts using the rich, free template library built into WPS Spreadsheet. Enjoy a lightweight, easy-to-use suite that supports standard Office formats and requires zero learning curve.
- 1. Download and Install WPS Office: Visit the official WPS Office website and click 'Download WPS Office Free' to get the lightweight installer.
- 2. Open WPS Spreadsheet: Launch the application and select 'Spreadsheet' from the home screen to start managing your project data.
- 3. Access Gantt Chart Templates: Click on 'Templates' in the top menu and search for 'Gantt Chart' to instantly load a fully formatted, ready-to-use project tracker.
Frequently Asked Questions
Can I use custom text fields instead of Flag fields to format milestones in MS Project?
MS Project's Bar Styles dialog relies on built-in task types or Flag fields (Yes/No) to trigger formatting. If you want to use a Text field, you must write a formula in a custom Flag field that returns 'Yes' when your Text field matches a specific value, and then format based on that Flag.
Why are my custom milestone icons not showing on the Gantt chart?
First, verify that the 'Show For ... Tasks' criteria in the Bar Styles dialog exactly matches your task properties (e.g., 'Milestone, Flag1'). Second, ensure that your custom style row is placed lower in the Bar Styles list than the default 'Milestone' row, so it correctly overrides the default formatting.
How do I change the default milestone shape for the entire project?
Right-click the Gantt chart view, select 'Bar Styles', find the default row named 'Milestone', and simply change the shape and color settings in the 'Start' or 'End' tab at the bottom of the dialog. Click 'OK' to update all standard milestones.
Can I export my Microsoft Project Gantt chart to Excel or WPS Spreadsheet?
Yes. You can export task data into a spreadsheet format via 'File' > 'Export' > 'Save Project as File'. If you want the visual Gantt chart itself, use the 'Copy Picture' feature in MS Project to take a snapshot of the chart and paste the image directly into Excel or WPS Spreadsheet.
