Combined Stacked Bar Chart

[dreid1011]

I am trying to make a stacked bar chart, but I can't seem to figure out how to move the data points around to get what I want. I have 5 sets of data like the two below (A:F and G:L):

2023-24 Tax Statement Mailing Results By State.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1		TOTAL MAILED	22586
2	STATE	COUNTY	PIECES	% OF TOTAL MAILED (ALL PIECES)	TOTAL MAILED	TOTAL BY STATE	STATE	COUNTY	PIECES	% OF TOTAL MAILED (ALL PIECES)	TOTAL MAILED	TOTAL BY STATE
3	OR	057 TILLAMOOK	11056	48.95%	22586	19420	WA	011 CLARK	563	2.49%	22586	1364
4	OR	051 MULTNOMAH	2556	11.32%	22586	19420	WA	033 KING	274	1.21%	22586	1364
5	OR	067 WASHINGTON	2200	9.74%	22586	19420	WA	053 PIERCE	65	0.29%	22586	1364
6	OR	005 CLACKAMAS	1621	7.18%	22586	19420	WA	061 SNOHOMISH	53	0.23%	22586	1364
7	OR	047 MARION	413	1.83%	22586	19420	WA	063 SPOKANE	49	0.22%	22586	1364
SUMMARY

Cell Formulas
Range	Formula
D3:D7,J3:J7	D3	=C3/SUMMARY!$C$1

Ultimately, I want to have 5 stacked bars, one for each state, consisting of the 5 counties with their respective % (% of Total Mailed) of the total (Total Mailed). With the 100% of the chart being the Total Mailed. I can get different variations of what I want, but not exactly what I am looking for.

 

[awoohaw]

I'm not sure what columns you want to stack:
This:

or This:

 

[dreid1011]

I'm not sure what columns you want to stack:
This:
View attachment 100766


or This:

View attachment 100767

Thank you for trying. This is what I was ultimately after and apologies for not making it clearer originally:

I ended up with just a cluster bar graph for each set of data.

 

[awoohaw]

Then try this:

 

[dreid1011]

Then try this:
View attachment 100779

I thought that might be how I needed to set it up, but I kept not wanting to do the table like that with blanks for some of the rows. Anyway, the boss went with a pie chart I think so thank you for the help.

 

[awoohaw]

I thought that might be how I needed to set it up, but I kept not wanting to do the table like that with blanks for some of the rows. Anyway, the boss went with a pie chart I think so thank you for the help.

well, the boss is the ultimate arbiter. But, there is ALOT of bias against PIE Charts these days. They take up a lot of space and don't really give much detail.
Of course, if you need to display the underlying data the stacked column 100% chart uses space up as well.

Best wishes to you!