cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
tajrida
Level III

How to color continuous data histogram based on category data?

Hello,

I have two(2) columns:

1. First column contains continuous data on turn around times.

2. Second column contains categorical data (types of departments) eg: microbiology, histology, chemistry etc.

when I create a histogram distribution of turn around time data and use local data filter to filter out departments: I would like to see a different color histogram for different color department.

Right now all departments show the default histogram color. I tried using "color or mark by column" feature but apparently this feature does not work for histograms

Mohammed Ahmed
1 ACCEPTED SOLUTION

Accepted Solutions
louv
Staff (Retired)

Re: How to color continuous data histogram based on category data?

One color for each sex (Blue=F, Pink=M, and Purple=Both M&F). The third color to show the overlap.

The histograms are presented separately below

8536_Screen Shot 2015-04-13 at 10.54.34 AM.png

8538_Screen Shot 2015-04-13 at 10.54.49 AM.png

View solution in original post

5 REPLIES 5
louv
Staff (Retired)

Re: How to color continuous data histogram based on category data?

Would this Graph Builder output work?

8534_Screen Shot 2015-04-13 at 9.16.36 AM.png

tajrida
Level III

Re: How to color continuous data histogram based on category data?

LouV,

I think we are half way there. I do need to present these histograms separately for each category. In your case there will be a separate chart for male and female.

BTW: why do you have three(3) different colors for two(2) levels of sex?

Thanks for your help!

Mohammed Ahmed
louv
Staff (Retired)

Re: How to color continuous data histogram based on category data?

One color for each sex (Blue=F, Pink=M, and Purple=Both M&F). The third color to show the overlap.

The histograms are presented separately below

8536_Screen Shot 2015-04-13 at 10.54.34 AM.png

8538_Screen Shot 2015-04-13 at 10.54.49 AM.png

tajrida
Level III

Re: How to color continuous data histogram based on category data?

Perfect Thanks!!

Mohammed Ahmed
louv
Staff (Retired)

Re: How to color continuous data histogram based on category data?

8539_Screen Shot 2015-04-13 at 11.09.44 AM.png