How to color continuous data histogram based on category data?

[#1]

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

[#2]

Would this Graph Builder output work?

[#3]

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!

[#4 · Accepted 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

[#5]

Perfect Thanks!!

[#6]