Color in staright Table field = scatter chart field.

[kishorj1982]

Hi

Can someone look in the attached and let me know how we can get the same background color for 'Name' field in the staright table same as that of 'Name' field bubble in scatter chart when persistent colors option in the scatter chart is ON.

Please let me know.

[kishorj1982]

can someone please respond?

[settu_periasamy]

Hi Kishore,

Like this you need?

Just i used in the background color expression like -> Color(RowNo())

But it will change based on your selection. May you can create the RecNo() Field in your Script and put it in your color expression. Like =>    Color(RecNoKey)

[settu_periasamy]

Hi,

Find attached the Updated version.

[Gysbert_Wassenaar]

Perhaps this blog helps you: Colors in charts‌.

[Kushal_Chawda]

The best way to do it is define the RGB Values for each item like below. Create separate spreadsheet for this

Item       R     G     B

Item1   120  120  120

Item2    150  111  60

like for all item

Now link this spreadsheet to your actual data with Item as key

Now In Chart either in dimension or expression

just use below expression in Background color

=RGB (R,G,B)

[kishorj1982]

Thanks all for your suggestion. I can create seperate table with RGB values and join with the key. But thing is that my output changes with respect to user selections and I need to have consistency between the scatter chart and straight table.

Now suppose I have 18 colors each are keyed with respect to RGB values with the Fact table data. If I am getting only 5,6.9 value, respective RGB colors will be populated in the straight table. But what about the scatter chart ?

can we control colors of the scatter chart by using expression?

[kishorj1982]

OK I got it. We can control colors in scatter chart by setting expression on Background color option of the First Expression.

Thanks all for your help