bar chart change color

[Karthikeyan A]

Is there anyway to assign colors to bar chart

[Davin Studer · Accepted solution]

Yep. In the macro properties it is the Colors field.

image2014-10-14 10:44:43.png

image2014-10-14 10:45:32.png

image2014-10-14 10:44:43.png

image2014-10-14 10:45:32.png

[Karthikeyan A]

Thanks Davin. I would like to know if we can assign colors based on the table value(sql output).

eg:

col1 col2

AB     4

BC     10

DE      6

I want to assign red color for AB, green  for BC , blue for  DE  and yellow  for FG (FG row  may or may be in the table based  on sql query output).

[Davin Studer]

Are you saying that you want the color to change based on the value in col2 for each row? Or is a static color for each row what you want. I don't quite understand your previous comment. If you want it to be dynamic I don't think that is possible. If you want a static color, then your first color would be for row AB, the second would be for BC, the third for DE, and the fourth for FG ... if it exists. You can put in four values even if there are only three rows.

[Karthikeyan A]

thanks david. Sorry for not elaborating the question the color should assigned for values not for rows. if the query output is AB 4 DE 6 Then i want to see Red and blue bars. Is that possible?

[Davin Studer]

Like I said I don't think it is possible to assign the color based on the value returned in your query. I cannot think of an easy way to do it.

[Karthikeyan A]

thank you Davin

[Katerina Rudkovskaya _Stiltsoft_]

Hello @Karthikeyan A ,

Please note that using the Chart from Table macro of Table Filter and Chart for Confluence app you can try the Multicolor scheme in the Column chart type (since version 7.3.0):

Katerina
Stiltsoft

[Katerina Rudkovskaya _Stiltsoft_]

Hello, 

Please note that we've released the 7.9.0 version of Table Filter and Charts for Confluence, added the capability to select custom chart colors from a table.

Select the corresponding columns with colors for the Colors in the table columns option. 
You can use colors from this list or define your own HEX code colors.

Katerina
Stiltsoft