Skip to main content
Planview Customer Success Center

Report Designer-Specifying Fields to Determine Colors for Bubble and Gantt Chart Items

You can specify in Report designer colours for chart items in Gantt charts, based on the values of UDF code fields, but you can not specify which value will have which color directly, the color is chosen by the engine.


1. You need to create two additional custom fields:
- A text custom field that will contain the value of the color to be used in the report
- A numeric custom field that will calculate and insert in the previously created custom field the right color according to the value of the needed UDF code

2. You need to create and use a CPCALC store procedure that will calculate and insert the hexadecimal value of a color in the first custom field you have just created. This color is chosen according to the value of the based field id that needs to be colored in the report. The store procedure is used by the numeric custom field you just have created.

3. In Report Designer, you have to choose the text custom field as base to display the color you want.

4. As the legend will display the code color instead of intelligible values, you have to create your own legend