Project to Milestones Wizard - Coded symbols

The Coded Symbols chart type makes it easy to map a Microsoft Project schedule to a presentation Milestones chart.  

The Coded Symbols chart type makes it easy to map a Microsoft Project schedule to a presentation Milestones chart.  

The technique is straightforward:

1. Set up a few Microsoft Project fields (text and number fields not otherwise being used in the Microsoft Project schedule)

2. One of the required fields is the "Code" field.  All Microsoft Project tasks with the same entry for the Code field will be placed on the same row on the Milestones schedule. 

3. Other required fields (milestone level, baseline level, actual level, symbol color, date placement and text placement) control how the information is presented.

4. Other coded import formats are available.

Here's an example of how a Microsoft Project schedule might be coded.  (The numeric fields are Microsoft Project Number fields.  The Code field (AKA Rollup field) is a Text Field (Text 1 in the example below):

• Row Name: A text field that contains the row names by which tasks will be grouped.

• Milestone Level: A number field that contains the level for each Milestone (upper, middle, lower = 1, 2, 3)

• Toolbox Symbol Type: A number field containing the Toolbox Symbol TypeToolbox Symbol Type

  Use the following as an illustration for symbol and connector numbering.

  

• Symbol Color: A number field that contains the desired Symbol Color:Symbol Color:

  

• Symbol Size: A number field with the desired Symbol Size (0.25 to 5.0)

• Symbol Date Placement: A number field with the appropriate Symbol Date PlacementSymbol Date Placement

  For the Microsoft Project Coded Symbols import format, use these numbers to position the symbol date and text.

      

  1  center middle

  2 center top

  3 center bottom

  4 left middle

  5 left top

  6 left bottom

  7 right middle

  8 right top

  9 right bottom

  10 bar middle

  11 bar top

  12 bar bottom

  13 hide

   

• Symbol Text Placement: A number field with the appropriate Symbol Text PlacementSymbol Text Placement

  For the Microsoft Project Coded Symbols import format, use these numbers to position the symbol date and text.

      

  1  center middle

  2 center top

  3 center bottom

  4 left middle

  5 left top

  6 left bottom

  7 right middle

  8 right top

  9 right bottom

  10 bar middle

  11 bar top

  12 bar bottom

  13 hide