@@jiejennThanks. If I need to put the primary users and secondary users in column B and C, how do stack primary and secondary users and make it side by side with stack repeat and new users? Two clustered bars with two stack information?
if the data is in 4 columns & I need first two as Column chart, other two into stacked. Thus overvall 3 bars, where the last one is stacked of 3 & 4 column data . for this type, how many spacer columns needed ?
@@jiejenn thanks Jenn. on the stacked bars - when you changed the gap of the bottom series and the top looked like it was hanging. Then you pressed the keyboard to align them - that’s what I’m referring to.
@@jiejenn very much in deed... I received an appreciation for this as well since others dint know how to go about... All credit to you.. there were similar videos but yours helped and answered exactly what I wanted.. thanks for your videos 🙏
But what if you only have 1 stacked bar in your chart, not multiple bars, or 7 bars as your example? When I add the line, it shifts the bar over to the far left of the chart and has a line going across part of the stacked bar and extending to the blank space on the right half of the graph. It will not center the bar.
@@jiejenn I think what they are asking is - what if you have more than 3 columns, like your example. For instance, if there are 5 columns, 4 of which should be stacked, and only 1 to be left as a cluster, how many spacer columns (or rows) would you add?
I literally spend an hour finding a solution for this. Thanks man!
Glad the video helped.
Thanks for this Jie - very useful
Lifesaving! Thank you so much!
Any way to hide spacer column from data table, as I've to show data table below chart.
Gonna cry after I see exactly what I am looking for!!!
Glad the video helped.
Me right now huhu
@@jiejennThanks. If I need to put the primary users and secondary users in column B and C, how do stack primary and secondary users and make it side by side with stack repeat and new users? Two clustered bars with two stack information?
Very effective, thank you❤
god-tier content. Kittos avusta!!!
This is amazing. Thanks!
thanks for your help, really saved me :)
Can I make this in 3D columns ?
you're a life saver man!
Thanks man. You saved my entire day worth of effort. 🤝
how can I move the stacked bar charts to the left of the clustered bar chart instead of to the right?
Thank you!! Just what I needed!!
Glad the video helped!
Thank you very much this is what I need
You saved my life. Thank you!
great video!
Thank you. Great video, exactly what I needed. Quick question - what is the purpose of adding the “spacer” column?
if the data is in 4 columns & I need first two as Column chart, other two into stacked. Thus overvall 3 bars, where the last one is stacked of 3 & 4 column data . for this type, how many spacer columns needed ?
Thank you very much, exactly what I needed 👍
This was awesome. Thank you.
you save my life!!!! thank you :)
Pls what did you press to align the stacked bar
Can you be more specific?
@@jiejenn thanks Jenn. on the stacked bars - when you changed the gap of the bottom series and the top looked like it was hanging. Then you pressed the keyboard to align them - that’s what I’m referring to.
You set the gap value then tab out.
Fantastic. Thank you!🥰
One problem I am facing is that the browser is coming up for bar type selection instead of user in combo chart option...so I can't go further.
great! Thank you!
So helpful.. thank you so much.. you made my day 🎉👍
Glad the video helped.
@@jiejenn very much in deed... I received an appreciation for this as well since others dint know how to go about... All credit to you.. there were similar videos but yours helped and answered exactly what I wanted.. thanks for your videos 🙏
Is there a way to hide the spacer column? I have to add a data table in the graph.
Unfortunately I haven't able to find a work around.
Great Job! super helpful!
Thank you!!!!
thank you very much
Thank you the video was really helpful ❤
Is this possible with horizontal bars by any chance ?
You should be able to since you are basically rotating the axis.
@@jiejennDidn't think you could do that !
Thanks, I couldn't align without this structure.
thank you very much very creative to make the space column then make it invisible
👍👍👍
Then how to remove spacer
But what if you only have 1 stacked bar in your chart, not multiple bars, or 7 bars as your example? When I add the line, it shifts the bar over to the far left of the chart and has a line going across part of the stacked bar and extending to the blank space on the right half of the graph. It will not center the bar.
This is something I am unable to help without look at how you set up your table unfortunately.
@@jiejenn I think what they are asking is - what if you have more than 3 columns, like your example.
For instance, if there are 5 columns, 4 of which should be stacked, and only 1 to be left as a cluster, how many spacer columns (or rows) would you add?
this lia gharani is totally basic compared to you. she probably should teach excel to children.
thank you so much, exactly what I needed!