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
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.
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.