Forum Discussion
NKumar2010
Apr 22, 2022Brass Contributor
How to display Custom column data in Gantt Chart in Project 2016 ?
Gantt chart by default displays only duration and % complete data for a task. I have created a custom Number 1 column which calculates % time elapsed and comes in decimal. I then have a Text 1 col (say Planned % Complete) , which converts this decimal data into % value.
In gantt chart, it shows duration and % complete. I want Planned % Complete also to be shown in the gantt bar. How do I show this ?
I created a custom table, in which I added Number1 and Text 1 (i.e. Planned % Complete) columns. Then created a new view and linked the view with this custom table. In this new view, Gantt chart still shows duration bar and % complete bar. So how do I show Planned % Complete data as a bar in Gantt chart ?
Thanks,
Nk
- NKumar2010,
The "Complete through" is derived from the mean duration and therefore has no relation to your custom text field for your Planned % Complete. In order to define the "From" and "To" criteria for your custom text field, you need to convert the end points of your Planned % Complete into dates in custom Start and Finish fields (e.g. Start1 and Finish1).
John
- John-projectSilver ContributorNKumar2010,
You need to create a new custom bar style that represents your custom field. Go to, Gantt Chart Format > Bar Styles group > Format > Bar Styles, and at the bottom of the list define the Name, Appearance, and other attributes of the new bar.
Understand that the priority of bar in the list of bar styles is from the bottom, that is bar styles at the bottom of the list will supersede any conflicting bars at the top of the list.
Hope this helps.
John- NKumar2010Brass ContributorHi John,
when I add a row at the bottom and choose a Name, Appearance etc. it overrides the appearance of existing bars displayed. It's happening probably the bottom of the list supersede bar style, as you said above.
What I'm expecting is probably two bars per task - First bar showing duration & % complete (This appears by default) and the 2nd bar showing % Planned complete. The 2nd bar is the customized bar, which I'm trying to create.
I don't know whether having two bars per task is even possible.- John-projectSilver ContributorNKumar2010,
The Bar Styles allows up to 4 bars per task line. This is set by the "Row" in the Bar Styles window. Actually you can get even more bars by careful selection of the bar Shape.
John