colour in charts

[Avisto.sbu]

Hello,

I want to create charts with colors linked to categories, these colors are stored in the database

for example we have a category product1 product 2...
I want that product 1 takes the color #FFABCD stored in the database, the product 2 the color #00FF00 ...
And that colours should be applied to the chart
if a category is missing it won't impact the others

How can I do that?

thanks for your answer

[MFGF]

Hi,

I don't know of a way to take hex colour codes from a data item and apply them. You can define conditional palettes to specify within a report that (for example) Product 1 is displayed as colour #FFABCD, and you can copy the palette from one chart to another, but I don't know of a way of defining these colours in your database.

MF.

[promji]

try setting up variables for the color values from your data item and use a  rich text item with java scrip to set the cell colors.

not the best solution but might work.

cheers.