Stacked Bar Chart Issue

What exactly do you need help with?

I would expect a process similar to this:

1) A sort step to sort each column from small to large
1a) This could be done using the built in Sort command on each column.
1b) or you can use the SMALL() or LARGE() function to sort the data in a helper column/range. (help file for LARGE() function. SMALL() function is similar https://support.office.com/en-us/art...b-01672ec00a64 ).
2) Chart should automatically show the data in the first row as the bottom stack and working on up from there.
2a) If you used SMALL()/LARGE() functions in a helper range, you will need to change the chart's source data to refer to the helper range.

Is that close to what you want?

That is correct, but that is how stacked column charts work. Here are some ideas for "re-establishing the connection" between each data point and its original category.

1) Format all data series the same, and use data labels to indicate which category each stacked column belongs to. This is probably the easiest to implement, but it could be the most difficult to read. With as many data points as you potentially have in the chart, the chart could get very busy with all of that text.

2) Format each data point individually so that all points for each category are formatted the same.
2a) If this is a one time thing and you are unfamiliar with VBA programming, it will be easier -- even if it is tedious -- to manually format each data point the way you would like.
2b) If you will need to do this frequently, you will almost certainly want a VBA procedure that will loop through each data point in each data series and format it accordingly. This will probably be the most "expensive" approach up front (especially if you will be learning VBA from the bottom up along the way), but it will give you a nice procedure that will fix this up for you whenever you need to do this task.

However you decide to approach this, you will need to do something in the spreadsheet to readily identify what category goes with each data point. Exactly how to do this will depend on the approach you chose to sort the data points.