Need help making histogram

As I suggested, I think the first thing I would do is to combine all three tabs into a single good database -- adding soap # as a field. You can use Get and Transform, if you want -- it is a useful utility to learn how to use. At the same time, you only have 3 soaps, so it should be easy enough to manually copy and paste to get the tables merged together.

The power of putting everything into a single database is illustrated in how it simplifies your average functions in K5:K13. Right now, you have to manually choose which cells to include in each average. With all of the data in a single database, a single AVERAGEIFS() function (paying attention to relative and absolute references) would compute all of these averages. Something like =AVERAGEIFS(water volume range,soap # range,H5,pump qty range, I5) (note that you need to unmerge H5 and repeat the soap # for each row -- most experienced users of Excel around here don't like merged cells anyway). Changing this to an AVERAGEIFS() function is good practice, because the AVERAGEIFS() function is very similar to the COUNTIFS() function that I would use for the histogram count/frequency data.

AVERAGEIFS() help file: https://support.office.com/en-us/art...8-f7c5c3001690
COUNTIFS() help file: https://support.office.com/en-us/art...c-aa8c2a866842

Assuming column M is your "bin" range for faucet time (and that you have combined everything into a single database), I would construct the table with the frequency counts like this:

1) Enter soap numbers in N1:P1
2) Count the frequency data using COUNTIFS() =COUNTIFS(faucet time range,">="&$M2,faucet time range,"<"&$M3,soap # range, N$1) [corrected] for all but the last "overflow" bin, where you remove the "faucet time range is less than next row of column M" arguments. Note the mix of relative and absolute references that I used for easy copying. Then copy down and across.
2a) Adding other variables, like pump qty should be as simple as adding additional columns and additional criteria to the COUNTIFS().
3) Build the histogram(s)/column chart(s) from this data. Details depend on exactly what you want to do here -- separate histograms for each criteria? Try to combine it all into a single chart? or whatever.

I will also note that, if you put all of your data into a single database, a pivot table may also do these summary steps faster and more efficiently. I am not very good with pivot tables, but you may want to explore that option as well: https://www.excel-easy.com/data-****...ot-tables.html