Cluster/Stacked Bar Chart?

The most common approach I see is this one: https://peltiertech.com/clustered-st...mn-bar-charts/ Note that the chart itself is a simple stacked bar/column chart, and that most of the work to make it a clustered and stacked is in arranging the data in the spreadsheet.

I am having difficulty applying this method for some reason. Was hoping for more help.

Your sample file does not show any of your attempts, so I do not know what part you are having trouble with or what part you are not understanding. I am also unsure exactly how you want the data to appear in the chart. I can see that you have dates and 2 categories (hourly/salary) for each data. There are 5 "data" groups and nothing that talks about "divisions".

In the end, I expect we will use Peltier's technique, so it is essential to understand exactly how Peltier's technique works -- how spacing the data out in different rows/columns with the blank rows/columns/cells in between combine to give the clustered and stacked appearance. Help us understand exactly what you want, what you do and don't understand, and we'll help you learn how to put this together.

Thanks. I am attaching an updated chart that is closer to what I am looking for, I just need the columns clustered.

Assuming I understand, putting your divisions in the place of Peltier's commodities, your dates + "hourly/salary" are in the place of Peltiers quarter + budget/actual, creating this is just like Peltier's tutorial:

1) Select the full table A1:K8 (I included the Totals row for good measure, it can be removed at the end, if desired). Insert chart -> stacked column. My copy of Excel chose to put the dates along the category axis, so I executed the Switch row columns to put the divisions along the category axis.
2) Insert 4 rows between each division and between division 5 and the totals row.
3) Move the hourly/salary data for each date down so that each data is in its own row. In order to avoid the chart series definitions "moving" as I move the data, I often prefer to use a copy-paste-go back and delete procedure rather than a cut-paste procedure.
4) Check each data series to make sure that Excel is still using the correct definitions for each data series (make sure it did not shift any of the data series down while you were moving data). Remove the Totals row from the chart, if you don't want it in there.

At this point, you should have a clustered and stacked column chart. Additional steps if you want.

5) Add an additional blank row between each division if you want a blank space between divisions in the chart.
6a) Move the division names down 2 or so rows (again, I prefer copy-paste-delete over cut-paste) so that the division names will be roughly centered under each grouping. -Or-
6b) Follow Peltier's instructions for adding a dummy series and labeling it to add the category names.
7) Any other formats you like.

Nothing really different from Peltier's tutorial there, so be sure to spend some time with it and see how it all works together. As I noted, most of the work is working out the data arrangement in the spreadsheet.

In what way is it stacking the wrong data points? My guess is that something went wrong at step 4 -- checking the definitions of each data series.

What is it using for the horizontal category axis data? I would expect A3:A29 or similar range in column A.
What is it using for each series? It must be using the same row range as the horizontal category axis data for each data series. So, if the horizontal data is A3:A29:
10/1/2019 hourly should be B3:B29
10/1/2019 salary should be C3:C29
10/31/2019 hourly should be D3:D29 (even though D3 is blank because you moved this datum down to D4).
10/31/2019 salary should be E3:E29 (even though E3 is blank because you moved this datum down to E4).
and so on.

Did you end up with something different for the data ranges in the chart?

I finally got it to work, I want to thank you so much for your help. Is there a way to change the stacked chart so that hourly is on top of salary instead of how I have it now? Actually never mind I figured it out!