Painting randomly mini chart graph in straight table

[#1]

hi all,

i'm trying to define a unique color for graph in each row in mini chart, but it stays black.

for instance, in row number 1, the color of the mini chart graph is green, and in row 2 the color of the graph is blue. the rgb function will be defined by calculation.

the expression i'm using with is:

=rgb(rowno(Total)*7,rowno(Total)*5,rowno(Total)*2)

this expression works when i put it in the background color, but not when i put it in the text color of the mini chart.

by the way, if i'm defining a specific color - the color of all the raws of the mini chart are changing. but it doesn't work with calculation.

please advise,

Or

[Gysbert_Wassenaar]

As you've noticed all the mini charts will use the same setting. It's not possible to use an expression that uses dimension values on a row-by-row basis.