colours in x-axis

[#1]

Hi All.

is it possible to get different colours for the values of x-axis? I'd want the label 2016 in red, 2015 in blue..

thanks in advance

luca

[agni_gold]

I think , it is not possible for dimension ,

But you can make same color for whole dimension. like below.

[Gysbert_Wassenaar · Accepted solution]

You can use a combi chart and add a second expression: =dual(Year, 0). Set the display option of that expression to Text on Axis only. You can then change the background color of the text by clicking on the + in front of the expression and enter an expression that calculates the color: pick(match(Year,'2016','2015','2014','2013'),red(),blue(),black(),green()). Replace Year with the name of your year dimension. See below for a similar example

[agni_gold]

In this case we need to do hard coding for that

[#5]

Agnivesh, Gysbert, many thanks for your reply.

Gysbert, your solution works!

Is it possible to vertically align the text (England, Greater London..)?

luca

[Gysbert_Wassenaar]

Vertically align? Do you mean rotate the text 90 degrees? That's not possible. But perhaps you can change the orientation of the chart to horizontal bars. You can do that on the Style tab of the properties window.

[#7]

thanks..