BookmarkSubscribe

Colors for Column Names

Often I work with tables that have many columns. Scrolling back and forth to get to a certain area of the table can be inefficient if I have to stop periodcially to see where I'm at and then try to remember if I've gone too far or not far enough.

 

It would be wonderful to be able to assign colors to the background of column names. This way I can color-code sections of the table and quickly find what I want. Being able to assign a color to a group of columns would also be useful. It would be super great if the colors would also appear in the column window on the left also.

 

Thanks much and keep up the great work.

Tracking Number:

Defect ID:

2 Comments
Super User

You can already do that 

 

Names default to here(1);
dt = open("$SAMPLE_DATA\Big Class.jmp");
Column(dt, "height") << Color Cells( "Red" );

Or click a column header to select the whole column and right click the values.  Go to color cells and choose your color. 

 

I like to do this with column groups and have entire groups be a color.  

Names default to here(1);
dt = open("$SAMPLE_DATA\Semiconductor Capability.jmp");
cols = dt << Get Column Group("Processes");
For(i=1, i<=nitems(cols), i++, 
	cols[i] << Color Cells("Light Blue");
);

 

 

Community Member
Hi Vince,

Thanks for the response.

My desire here is to color just the headers, not the cells. I do use cell colors for specific cells, but for me coloring all the cells in a column group is too much.

Right now, I also use a blank column with the cells colored in to delineate boundaries between groups of columns but that’s kind of clunky.