Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Highlighted
Level III

## how to keep cell color of JMP table

Hi,

I made a script that check last 30 days average and color in red if its above or bellow 1/3 of my limit

(assuming i keep my limit in 3 sigma it check for one sigma shift)

i can't save the color format into journal or XLS file, is there a way to share it with ppl that do not have JMP?

(I can't change zoom of JMP table so i can't even image capture it since its longer then one page...)

For( i = 1, i <= N Row( dt ), i++,

If( Column( dt, "Mean 30 days" )[i] > (((Column( dt, "Target" )[i])*2 + Column( dt, "Upper limit" )[i] )/3)

,Column( dt, "Mean 30 days" ) << Color Cells( 3,{i} )

)

);

For( i = 1, i <= N Row( dt ), i++,

If( Column( dt, "Mean 30 days" )[i] < (((Column( dt, "Target" )[i])*2 + Column( dt, "Low limit" )[i] )/3)

,Column( dt, "Mean 30 days" ) << Color Cells( 3,{i} )

)

);

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User

## Re: how to keep cell color of JMP table

In JMP 12, the cell colors are copied to a journal;  Given your above  script, you can add:

new window("my journal",<<journal);

dt<<journal;

Here is the journal output for a simple example I ran:

Jim
4 REPLIES 4
Highlighted
Staff

## Re: how to keep cell color of JMP table

Maybe something like this?

NamesDefaultToHere(1);

// Colour some cells in a table

dt = Open("\$SAMPLE_DATA/Big Class.jmp");

hCol = Column(dt, "height") << Set Property("Color Gradient", {"White to Blue", Range( 40, 80 )} );

hCol << Color Cell By Value( 1 );

// Make a PDF on the Desktop

nw = NewWindow("My Window", PanelBox("Big Class", dt << getAsReport));

nw << savePDF("\$DESKTOP/Big Class.pdf");

Highlighted
Level III

## Re: how to keep cell color of JMP table

the moment i make it into journal i lose the colors (making it to PDF after doesn'tbring the colors back)

* i have JMP 10

Highlighted
Super User

## Re: how to keep cell color of JMP table

I am sorry that I don't have a better solution

Jim
Highlighted
Super User

## Re: how to keep cell color of JMP table

In JMP 12, the cell colors are copied to a journal;  Given your above  script, you can add:

new window("my journal",<<journal);

dt<<journal;

Here is the journal output for a simple example I ran:

Jim
Article Labels

There are no labels assigned to this post.