🙌This is so good. Thank you it's exactly what I needed!!
@ArmchairDeity
4 жыл бұрын
OMG THANK YOU!! I now have a chart with COVID-19 "Tested" vs "Ruled out, pending, dead"... that way I can compare what's going on with the testing. I really appreciate you giving me exactly what I needed to do to make this happen. Simple, straightforward, and easy to follow. Awesome!
@exceldashboards
4 жыл бұрын
So glad to help!!! Thanks for the great comment!
@frndbinu
3 күн бұрын
Super helpful. I just made one
@bails1310fcjq
3 жыл бұрын
Thanks you so much. I’d done most and failed at the deleting of the second axis, really helped me and well and truly subscribed.
@tedo1908
2 жыл бұрын
Best video on KZitem. Thank you!
@patrickkelly4845
4 жыл бұрын
This video truly got me out of a bind so I thought I could help you. at the end you said the labels could not be centered but they can. If you click in the original table that you put the words in and hit the space bar however many space you need to center it. It will work I did it.
@ChrisChuUsa
Жыл бұрын
Thank God I found this! Thank you🙏💓
@alejandroazofeifa5555
2 жыл бұрын
Great, you saved my day, thanks a lot ! Greetings from Costa Rica...
@exceldashboards
2 жыл бұрын
You're welcome!
@BamaGlambert
7 жыл бұрын
Best excel resource on KZitem
@exceldashboards
7 жыл бұрын
Thank you so much for the AWESOME coment BamaGlambert! I appreciate it very much.
@Dking12xs
3 жыл бұрын
Thank you very much man!!!!!!
@priscila187
3 жыл бұрын
Thank you!!!!!!!!!!
@pritamagawane8207
6 жыл бұрын
nicely explained the steps and also the probable issues with solution for most of them - much appreciated. Thanks :)
@exceldashboards
6 жыл бұрын
Thanks for the great comment. So glad to help. Much appreciated.
@halginthomas9262
3 жыл бұрын
Appreciate for this video it helped me, but struggling to align the primary axis with secondary. As in the video Jan Total sale is 270 {150+140} therefore the clustered bar and the Stacked bar{ Tea and coffe} should be aligned at same level. Here the bar is showing the total sale of Jan is less when compared to total of Tea +cofee individual sales. I tried to change the scale of secondary axis didn't come right. Can you please help to resolve this.
@osoroosoro2551
6 жыл бұрын
Thank you this was very clear and helpful
@exceldashboards
6 жыл бұрын
Awesome, so glad to help. Thanks for the nice comment.
@alexlara5873
4 жыл бұрын
Is there a way to add a third measurable to the tea & coffee while keeping your goal bar intact? Sorry, I’m a beginner.
@pramodgaikwad3410
3 жыл бұрын
Thanks for your guidance, But your subtitling / revoicing at the bottom of screen with black background disturb me to understand the curser movement & actions, so pl change it to right corner with transparent backround
@jackiefeng7550
Жыл бұрын
What is the reason add two columns of filters
@mrtravikanth
4 жыл бұрын
Very helpful, thank you! But, a small query. Will you be able to manage th bottom axis (months) should me in middle instead
@exceldashboards
4 жыл бұрын
I think you are asking if you can move the months to the middle of the columns. No you cannot. It is being centered on 1 axis and you are moving the 2nd axis to the side to make it visible.
@fadli2108
3 жыл бұрын
Thank you, I have 365 but I managed to do same technique
@froyed1978
5 жыл бұрын
Nice and easy Thanx bro
@exceldashboards
5 жыл бұрын
Thanks for the great comment. Much appreciated.
@Bill-ck3lo
4 жыл бұрын
I did this exact thing and when I change chart type, it stacks all columns not just the secondary axis!?! Why??? I am using Office 365. It looks like you're using an older version.
@sitinurizzatynorizan404
4 жыл бұрын
Hi there! I'm using excel 2016 and i do get the same issue like you. what i did was i change chart type to combo. and select the necessary column to be in the 2nd axis and change the chart type to stacked. and then it works.
@aremes007
3 жыл бұрын
How can i make a 3 level stacked - 2 column chart. I have data for number of manpower for electrician, mechanic and plumber distributed by months having the baseline and actual values. I want to see the difference between the baseline and actual per month in a chart. Thank you.
@Keyfts
4 жыл бұрын
Hi! Is there a way to add in Conditional Formatting to the stacked section of the chart?
@isalvare75
5 жыл бұрын
how can i do it fro 2 staked bars, side by side
@exceldashboards
5 жыл бұрын
Hi Ismael, unfortunately, you can't do it in the same chart. You can overlay multiple charts. However, if you add more data for additional stacks, you will just keep adding them on top of the current stacks.
@isalvare75
5 жыл бұрын
@@exceldashboards Oh ok. I tried pretty much every permutation LOL and couldn't get it to work. Any other suggestion on how to show this information?
@exceldashboards
5 жыл бұрын
Hi Ismael, you can overlay 2 charts, but make sure you like up the Horizontal of both and also make the Vertical axis values the same. If you want to put them in the same chart, you can do something like this, but it requires you to replicate the Budget or Single Column for each Product Grouping (Stacked Columns). Let me know what you think. Here is a link to what it would look like: www.exceldashboardtemplates.com/SampleMultipleStackedClusteredColumns
@isalvare75
5 жыл бұрын
@@exceldashboards Hi and thank you for your help. Do you have an email to show you what i am trying to do?
@exceldashboards
5 жыл бұрын
@@isalvare75 There is a contact form on : www.exceldashboardtemplates.com/ where you can send me your email and i can contact you.
Пікірлер: 38