I am trying to make pie chart and kind of creating table to its legends but how to manage those colors corresponds to those colors.
Thnaks in advance
Chart Properties > tab Colors > set the colors 1-5 on the left according to your desired colorcode. Also check the checkbox 'Persistent Color' to make sure, the colorcode doesnt change with use filters.
and if you would like to set a backgroundcolor to your table dimension (or expression) see dimension (or expression tab) Background color and insert the rgb() codes with an if() clause:
But how to create table in legends or should I make different table and If I created a different table how to add a collumn of color only instead of giving background color to all of row?
I think you need to solve this with an additional (straight) table. You just a add an empty expression (e.g. with a space character chr(32)) and set the background colors
And yeah that will work But Do you know how to make that expression collumn (char(32) one) the 1st collumn of the table.
So I guess you have a dimension as first column...you can just drag&drop the expression column in front of (left of) the dimension column
Retrieving data ...