PS: couldn't attach the Excel file for some reason - so sent it via picture
A picture is usually harder to debug from. I don't know what is up with the various uploader options on this site, but a lot of people have trouble. I do not know how you tried to upload. The only reliable upload method I have used here is to click on reply to thread or go advanced. Below the post editor is a "manage attachments" link that opens up the file uploader in another window/tab. See if that will allow you to upload a sample.

Looking at your pictures, I must not be understanding what you want to do. I thought you already had all the data you needed in the spreadsheet, so that the stacked column chart in the picture would be what you wanted.

One way or another, you appear to understand the mechanics of creating the stacked column chart. At this point, it appears that you have not yet calculated the data that you want to appear in your stacked column chart. It seems to me that, once you figure out how to calculate the desired values, you will be able to create the stacked column chart just fine.

Trying to reverse engineer how you got the histogram from the above data -- It looks like your histogram is counting the number of entries in Type1 column that fits in each bin. How are you generating this histogram -- from the histogram tool on the data anlysis menu, or are you using the FREQUENCY() [or COUNTIFS()] function? Will you use the same bins for each type, or will each type have its own bins? The bins in the histogram don't seem to match the bins/ranges in the original table (probably my misunderstanding what you wanted to do).

If you are using the Data analysis histogram tool, I would recommend that you learn how to use the FREQUENCY() function to create the histogram instead of the histogram tool. If you are unfamiliar with the FREQUENCY() function: https://support.office.com/en-us/art...7-fd9ea898fdb9 If I understand better what you want, I would expect a spreadsheet with:
1) A column of bins (6.56, 14.06, 21.56, 29.06) if they are going to be the same for each type
2) A FREQUENCY() function for each type =FREQUENCY(relative reference to Type1 column,absolute reference to bins column) -- pay careful attention to the array function nature of the FREQUENCY() function and how to correctly enter it -- select the desired range, enter the function, confirm with ctrl-shift-enter.
3) Copy the FREQUENCY() function across so that you have a column for each type
4) Create stacked column chart from the resulting frequency data.

Am I getting closer to understanding what you want?