How to change the color of gantt chart items based on column values

[Krishna Chaitanya]

I built a Gantt chart from a table using "Chart from Table" Macro. I have a column in the table "Status" which gives the status of each project. I'm trying to make the color of project items in the Gantt chart based on this status. For example, all completed as green, all in progress as blue etc. 

I tried using "Colors in table columns" and selected the column "Status" but that is giving me each project in different colors. 

I am sure I am missing something simple here and any help would be appreciated. 

Thank you!

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Krishna Chaitanya 

Did you take a look at the official documentation for the chart macro?

https://support.atlassian.com/confluence-cloud/docs/insert-the-chart-macro/#Gantt-Chart

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Krishna Chaitanya,

The Chart from Table macro allows you to choose from three color schemes within its Gantt chart:

1. Single color: the same colors for all the projects and to do/done items within different projects.



2. Multicolor: you can manually define colors for each project and to do/done items within different projects separately.



3. Colors in table columns: the colors are taken automatically from the additional manually created columns with colors in your source table.



Seems that smth is messed up here as you mention that you use only one column to get colors from. Please check the settings or use alternative color schemes.
And you can read about the colors of the Gantt chart here (please navigate to the “Set colors” section).

[Katerina Rudkovskaya _Stiltsoft_]

@Krishna Chaitanya, notice that you can add a column with color names based on your statuses with the help of SQL query like this via Table Transformer and then just hide it with Table Filter:

SELECT *,
CASE WHEN T1.'Status'="Done" THEN "green"
WHEN T1.'Status'="In Progress" THEN "blue"
WHEN T1.'Status'="To Do" THEN "grey"
ELSE T1.'Status'
END
AS 'Status color'
FROM T*