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.
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"
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.
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
![[UA] NAVI проти G2 Esports | Blast Premier Fall Final](http://i.ytimg.com/vi/QWlIm4FGESQ/mqdefault.jpg)
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!
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!
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!
TY Debra, the best explanation on YT. BY FAR!
Thank you, A A, and I appreciate hearing that!
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
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!
after 1 hour of trying methods to no avail- thank you so so much!!!!!!!
You're welcome, Lilies, and thanks for your comment!
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!
Thank you, short and sweet without any gimmicks.
You're welcome, and thanks for your comment! I'm glad you liked it!
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!
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!
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!
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
Special thanks for your explanation
You're welcome, Ahmed, and thanks for your comment!
Hey thanks a lot for sharing. This is just what I was looking for
You're welcome, and thanks for your comment!
Made my day. Thank you
You're welcome, Balchand, and thanks for your comment!
awesome explanation! Thanks!
You're welcome, Mahdi, and thanks for your comment!
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!
You're a life saver 🙌🙌
Thank you! I'm glad the video helped 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!
Absolute legend
Thanks!
Tengkyu.
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.
Hi Debra. Very nice technique! Thanks for sharing :)) Thumbs up!!
Thank you, Wayne! I appreciate your support!
So helpful
Thank you, I appreciate it!
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!
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"
Thanks
Thanks for watching, and leaving a comment!
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!
Muito bom !!!! Me ajudou de mais!
You're welcome, Bruno, and thanks for letting me know that the video helped you!
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!
Muchas gracias
You're welcome, Odette, and thanks for your comment!
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
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
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!
It didn't work for me