You're welcome, Catherine! There's no built-in way to centre the labels, but you could add space characters before the text in each label, as a workaround.
I have reactions to two statements in four categories (agree, neutreal, disagree, don't know) which add up to 100%, by three groups. When I organize the data as shown here, it stacks by column instead of by row. I reorganized the data to accomodate for this... it suddenly stacks by row leading to the exact same, wrong figure. I guess the auto interpretation by Excel just wins this battle.
@@contextures Thanks so much for taking the time to help. I actually figured out that there was no need for dividing the responses in different lines in my case. I used the 'Clustered Stacked Bar Chart in Excel' guide by @Pandi Mengri instead.
That was really helpful! I wonder how can we center the titles east, west north and south at the end of our chart? I mean, it seems each of them only represent the first column at their point, respectively.
Thanks, Kerem! To move the labels over a bit, you could add space characters at the start of the region names, in the chart data. OR, insert a blank row between the 2 rows of data for each region, them move the label to that blank row. Then, to add more space between the regions, add another blank row or two between them in the data
Thank you for sharing. It's exactly what I need. However, I have a question, hope that you can reply. I want to create a clusterd stacked chart same as yours, but my horizontal axis is number (in Date format), and this method doesn't work for me. My alternative fields are as follows: + "region" => "month" (instead of "East-West-North-South", I change to Jan-2022, Feb-2022, Mar-2022, Apr-2022) + "year & season" => "Work & Plan/Actual" (instead of "2020 Win - 2020 Spr. - 2021 Win - 2021 Spr", I change to "Work A_Plan, Work B_Plan, Work A_Actual, Work B_Actual" The output chart only shows "Plan" value, no "Actual" at all. The problem can be fixed only if I change the format of Jan-2022, Feb-2022, Mar-2022, Apr-2022 to "Text". Do you know why?? Thank you.
You're welcome, and thanks for your question! If you haven't tried this already, right-click on the Months axis, and click Format Axis. For the Axis Type, select "Text Axis"
Hi. Can I make it work with a none four-by-four set of variables? I'm trying to compare two years, month by month, of about twenty inputs. Can't get it to stack side by side
Thankyou. I went to two very famous Excel channels. However nobody explained it as nicely and easily as you did.
You're welcome, and thanks for your lovely comment - I appreciate it!
This is the best way to plot this type of chart. So quick and easy, thank you!
You're welcome, Mimi, and thanks for your comment!
Very short and crisp video with utmost clarity. Thanks a ton for sharing.
Thank you, Sarvesh, and I'm glad you liked the video! --Debra
TY Debra, the best explanation on YT. BY FAR!
Thank you, A A, and I appreciate hearing that!
This has been very helpful for a complicated report I've been trying to do. Thank you so much!
You're welcome, HL, and thanks for letting me know the video helped with your complicated report!
Thank you, short and sweet without any gimmicks.
You're welcome, and thanks for your comment! I'm glad you liked it!
after 1 hour of trying methods to no avail- thank you so so much!!!!!!!
You're welcome, Lilies, and thanks for your comment!
You saved my presentation! Thank you very much!
You're welcome, Katherine, and thanks for letting me know that the video helped with your presentation!
Thank you very much for the tutorial! It was very easy to follow and effective!
You're welcome, and thanks for your comment! I'm glad you found it easy to follow
Amazing! Thank you. Exactly what I needed. None of the other explanations delivered this result.
You're welcome, Sean, and thanks for letting me know that the video had the explanation you needed!
Thank you for such a clear and concise explanation - just what I was looking for!
You're welcome, and thanks for letting me know the video had what you were looking for!
Special thanks for your explanation
You're welcome, Ahmed, and thanks for your comment!
Thank you so much, so saved my minutes of life. I also added 3 line chart into this charts as well.
You're welcome, Fahad, and I'm glad the video helped you save time!
awesome explanation! Thanks!
You're welcome, Mahdi, and thanks for your comment!
Made my day. Thank you
You're welcome, Balchand, and thanks for your comment!
This was exactly what I needed! Thank you a million!!
You're welcome, and thanks for your comment! I'm glad the video had what you needed
this is a very creative solution to make such a complicated chart, thanks a ton for sharing!!
You're welcome, Bo, and thanks for your comment!
Thank you so much but do you know at all how I can center the horizontal labels?
You're welcome, Catherine! There's no built-in way to centre the labels, but you could add space characters before the text in each label, as a workaround.
Thanks so much! This was super useful!
You're welcome, Hans, and thanks for letting me know the video was useful for you!
This was soooo helpful! Thank you!!!
You're welcome, Olivia, and thanks for letting me know the video was helpful to you!
EXCELLENT . MANY THANKS.
You're welcome, Jayaraman, and thanks for your comment!
Very helpful indeed, thank you!
You're welcome, Wojciech, and thanks for your comment!
You're a life saver 🙌🙌
Thank you! I'm glad the video helped you
Hey thanks a lot for sharing. This is just what I was looking for
You're welcome, and thanks for your comment!
Absolute legend
Thanks!
So helpful
Thank you, I appreciate it!
I have reactions to two statements in four categories (agree, neutreal, disagree, don't know) which add up to 100%, by three groups. When I organize the data as shown here, it stacks by column instead of by row. I reorganized the data to accomodate for this... it suddenly stacks by row leading to the exact same, wrong figure. I guess the auto interpretation by Excel just wins this battle.
To get columns per group per statement, enter data in this setup:
B1:I1 (headings "statement-response")
A-Ag, A-Ne, A-DA, A-DN, B-Ag, B-Ne, B-DA, B-DN
A3:I4 (group 1 response counts)
G1 20 25 25 30
30 35 30 5
A6:I7 (group 2)
G2 15 40 20 25
25 45 25 5
A9:I10 (group 3)
G3 15 30 40 15
15 40 40 5
Select A1:I11, insert stacked column chart
@@contextures Thanks so much for taking the time to help. I actually figured out that there was no need for dividing the responses in different lines in my case. I used the 'Clustered Stacked Bar Chart in Excel' guide by @Pandi Mengri instead.
@@BUwe You're welcome, and thanks for letting me know you found a solution!
Hi Debra. Very nice technique! Thanks for sharing :)) Thumbs up!!
Thank you, Wayne! I appreciate your support!
That was really helpful! I wonder how can we center the titles east, west north and south at the end of our chart? I mean, it seems each of them only represent the first column at their point, respectively.
Thanks, Kerem! To move the labels over a bit, you could add space characters at the start of the region names, in the chart data. OR, insert a blank row between the 2 rows of data for each region, them move the label to that blank row. Then, to add more space between the regions, add another blank row or two between them in the data
@@contextures Thank you so much!
@@maestros1327 You're welcome!
Muchas gracias
You're welcome, Odette, and thanks for your comment!
Thank you for sharing. It's exactly what I need. However, I have a question, hope that you can reply.
I want to create a clusterd stacked chart same as yours, but my horizontal axis is number (in Date format), and this method doesn't work for me.
My alternative fields are as follows:
+ "region" => "month" (instead of "East-West-North-South", I change to Jan-2022, Feb-2022, Mar-2022, Apr-2022)
+ "year & season" => "Work & Plan/Actual" (instead of "2020 Win - 2020 Spr. - 2021 Win - 2021 Spr", I change to "Work A_Plan, Work B_Plan, Work A_Actual, Work B_Actual"
The output chart only shows "Plan" value, no "Actual" at all. The problem can be fixed only if I change the format of Jan-2022, Feb-2022, Mar-2022, Apr-2022 to "Text". Do you know why??
Thank you.
You're welcome, and thanks for your question! If you haven't tried this already, right-click on the Months axis, and click Format Axis. For the Axis Type, select "Text Axis"
Hi. Can I make it work with a none four-by-four set of variables? I'm trying to compare two years, month by month, of about twenty inputs. Can't get it to stack side by side
Tengkyu.
Muito bom !!!! Me ajudou de mais!
You're welcome, Bruno, and thanks for letting me know that the video helped you!
is it necessary to do the arrangement like this? Won't it work if we leave one space after every row?
Make a copy of your data, and try that arrangement
Thanks
Thanks for watching, and leaving a comment!
I've tested that, and it's not working if you changed the Horizontal Axis into Date format. They would return into a single stacked charts
ganhou mais um inscrito !!!
Thanks, Bruno, and I appreciate it!
Thank you very much... I m able find out where i am making mistake... 🌹🌹🌹1000 roses for u...
You're welcome, and I'm glad the video helped you find the mistake. And thanks for the roses!
It didn't work for me