Subscribe Bookmark RSS Feed

How to color continuous data histogram based on category data?

tajrida

Community Trekker

Joined:

Apr 8, 2015

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

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

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

5 REPLIES
louv

Staff

Joined:

Jun 23, 2011

Would this Graph Builder output work?

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

tajrida

Community Trekker

Joined:

Apr 8, 2015

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!

Solution

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

Community Trekker

Joined:

Apr 8, 2015

Perfect Thanks!!

louv

Staff

Joined:

Jun 23, 2011

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