Current Selection box

[#1]

Hi All,

I have a requirement.

There is a chart and in which one column has just a background notthe value, If we are selecting this column, the current selection box should show the color instead of RGB values or blank.

Thanks in advance

[christian77]

Hi:

Unfortunately current selections boxes show fields and selected values. You can do the next: In your current selections box, open the title tab and set the color to calculated. Place your expression there like, =only(rcolor,gcolor,bcolor).

Remember that rgb() function has 3 parameters.

This might help you.

[#3]

Hi Christian,

this can happen only if there is one such column. what if there are multiple columns which has only colors as background.

Can we write any macro on this?

Thanks