How to create a cumulative S Curve chart. Check out courses at www.itseasy.co.uk or online at: www.udemy.com/course/microsoft-excel-intermediate-course-z/?referralCode=365DF21869A9F9D2BFCB
I've got a table that's the same layout but my graph is being plotted basically as 4 bar charts side by side. All the planned then all the actuals etc. And im not getting s curves, just more bar graphs. Any advice?
@@ITsEasyTraining1st nevermind. I'll explain in case anyone reading has the same things. Between my top row and the 2 underneath, I had loads of hidden rows of things being added up for the totals. I thought because they were hidden, Excel wouldn't have a problem with them to fix this, you could rearrange your rows so they follow the order on this video with nothing hidden in-between. What I did though was make a table on a different sheet where each square had a link to something on the original table
How to create a cumulative S Curve chart. Check out courses at www.itseasy.co.uk or online at: www.udemy.com/course/microsoft-excel-intermediate-course-z/?referralCode=365DF21869A9F9D2BFCB
Thanks for explaining of s curve progress 🙌
you are welcome
I can't believe how easy this is
I know
Thanks
I've got a table that's the same layout but my graph is being plotted basically as 4 bar charts side by side. All the planned then all the actuals etc. And im not getting s curves, just more bar graphs. Any advice?
Are you displaying a secondary axis?
@@ITsEasyTraining1st nevermind. I'll explain in case anyone reading has the same things. Between my top row and the 2 underneath, I had loads of hidden rows of things being added up for the totals. I thought because they were hidden, Excel wouldn't have a problem with them to fix this, you could rearrange your rows so they follow the order on this video with nothing hidden in-between. What I did though was make a table on a different sheet where each square had a link to something on the original table
This looks easy enough
Thanks
May I know why my bar does not appear even I try the method
have you tried to copy the data exactly
Hello
I might be asking a silly question but I am a beginner. Why you put "Actual cost" only till 25th Dec and not stretched it till 31st Dec?
Becuase that is where the actual project is, the 31st is the predicted end
@@ITsEasyTraining1st so it’s just an assumption right? No specific logic behind it. Correct?
I will use this
Thanks
Great job. A1
Thanks
This isn't a S-Curve, an S-curve is based on formula, is a theoretical model
ok
Explain? And source please?