DEV Community

Stan Brown
Stan Brown

Posted on

In Calc- how can I highlight a legend when opening a list?

Hello - I do hope I explain this correctly.

I have a spreadsheet in Calc which is used by/with a Python 3D scatter script. In addition to the x, y, and z values, I also have a column for marker type and plot color.

Both have a data validity list; however the list is the python syntax (that the script reads). I have a legend which explains each the meaning of each piece of code.

example:
For Markers "^" = triangle up, "<" = triangle left, "." = point, etc.

For colors r,g,b,c,m,y,k are the basic colors, afterwhich tab:orange, tab:purple,, etc.

Is there way to highlight the legend for marker or color when that list is opened? Some of the syntax will be meaningless to some users.

The Legen is currently in 2 columns not used for the 3D plot.

Thank you

Top comments (0)