Hi mastahswordz, Not sure why you would want to do this for this chart, but the simplest way would be to change the titles of the months to include the date, ie: change "January" to "1st January". Dr E.
Thanks for this... just to note - in Excel 2010, it will select the X axis automatically. So you will get a completely different result if you select up to the column March in your example from if you selected up to April.
Hi Dr. E, I was trying to follow our instruction to create the bar chart that I desire. However, the end result is not what I wanted. I wanted to have 2 bar chart lay out, with the first one called the Project Run Time and it spans from month 0 - month 12 (this is the easy part) and the second bar called Project Breakdown where I listed out the different stage, Start, Planning, Executing, Monitoring and Closing.
Hi Dr E, thanks I appreciate your reply. sorry i was looking for a way on how to create a gantt chart using stacked horizontal bar. And force the x-axis to return 1st day of the month
HI mastahswordz, Please check other videos in my channel on how to create and edit Gantt charts in Excel, plus some on using Resource Histograms (like stacked charts). Good luck with your studies, Dr E.
I will have different month span for different stage, and want them to end up stacking up on each other which total equals 12 months (equivalent to the first bar) This has given me immense amount of trouble, would you be possible to identify how I could achieve such task? Regards, Dr. E
How do I construct a chart that has 3 data sets in one bar chart, but lets say that the data set is as follow 100%blue, 74%red and 17% black how do I get the bar to show on the axis a max value of 100% with the 74% and 17% showing in the bar chart and not give me a total of 191% like a normal stacked chart??
Thank you so much Irish guy! Very useful stuff! I finished my assignment very quickly with your help.
You are very nice presenter sir. I'm relieved now. Pes, from Papua New Guinea
Sir you have saved my life!
Very nice. I was doing it on my data as you went through the tutorial. Very easy. Thank you.
Hi uugn,
Try putting percentage values in your cells (make sure they are formatted as "percentage").
Dr E.
Hi mastahswordz,
Not sure why you would want to do this for this chart, but the simplest way would be to change the titles of the months to include the date, ie: change "January" to "1st January".
Dr E.
Very helpful. Thanks.
Very well-explained
Thanks for this... just to note - in Excel 2010, it will select the X axis automatically. So you will get a completely different result if you select up to the column March in your example from if you selected up to April.
Hi Dr. E,
I was trying to follow our instruction to create the bar chart that I desire. However, the end result is not what I wanted.
I wanted to have 2 bar chart lay out, with the first one called the Project Run Time and it spans from month 0 - month 12 (this is the easy part) and the second bar called Project Breakdown where I listed out the different stage, Start, Planning, Executing, Monitoring and Closing.
love ur accent
Thanks so much
Hi Dr E,
thanks I appreciate your reply. sorry i was looking for a way on how to create a gantt chart using stacked horizontal bar. And force the x-axis to return 1st day of the month
Thank you.
alright. will do. thanks Dr E.
how do you force x-axis to use 1st day of the month when you use a stacked horizontal bar?
Nice and easy
HI mastahswordz,
Please check other videos in my channel on how to create and edit Gantt charts in Excel, plus some on using Resource Histograms (like stacked charts).
Good luck with your studies,
Dr E.
How to create a graph when you eant to show same chart but comparing year on year requirement of various resources.
I will have different month span for different stage, and want them to end up stacking up on each other which total equals 12 months (equivalent to the first bar)
This has given me immense amount of trouble, would you be possible to identify how I could achieve such task?
Regards,
Dr. E
Thank you
Thank you :)
How do I construct a chart that has 3 data sets in one bar chart, but lets say that the data set is as follow 100%blue, 74%red and 17% black how do I get the bar to show on the axis a max value of 100% with the 74% and 17% showing in the bar chart and not give me a total of 191% like a normal stacked chart??
very good
thank you! How do I add a column?
How to show percentage numbers in this chart?
Hi! How can I create the cylinder chart similar to that for a revenue goal that is divided into each month and show the progress of each month?
Hi KhloMng - without seeing your data, I can't tell how to do this.
Dr E.
how do you do?
nice yo
Legends watching this 2024❤
hi
how to use stacked bar chart
that graph is unreasonably ugly/ next video please…
Thank you.