Planned vs Actual chart in Excel | With Corrective Path
HTML-код
- Опубликовано: 21 авг 2024
- In this video, we will see how we can create a Planned vs Actual Chart in excel. We will plot a cumulative planned vs Actual chart using Line charts - we will also add a dynamic visual indicator that shows the corrective path required to meet the target. All this with the help of simple formulae - without VBA.
Click here to subscribe to my channel to get more videos of Excel formula tips and uses:
/ @exceltipsvideos
Check out our Video on how to create Heat Maps in Excel:
ruclips.net/video/JAwl6C2RiWM/видео.html
Greetings and hello. My name is Robert and I am interested in knowing, if you are available for small project work. I am looking for someone to help me with a few data sets in the very near term. If yes, please let me know. Many thanks, Robert
@@robertsalsa8823 Hi Robert, Thanks for reaching out to me. I am, however, unable to assist you due to other commitments.
@@ExcelTipsVideos thank you for letting me know. I’m interested in you particular practical approach and believe we would work well together. Please let me know, if you ever open up to new clients. Many thanks, Robert
Sir, thanks for sharing.very helpful for me. Again thank you very much.
You were born to teach, Sir. Excellent educational video, just polish it off by slowing down a fraction and zooming in on the changes you are making and why you are making, there are many of us new to Excel and need to be taken by the hand for a few moments until we can stretch our wings and throw ourselves out of the eagles nest and begin to fly!
Thank you for your kind words
Wow...great video...exactly what I was looking for. Modified to include dollars spent on a project and determine how many hours to charge. Thank you, Well Done!
Thank you for your support....
thank you sir for excellent video.
Welcome!
very helpful ! thank you very much
Glad it helped!
Thanks!
Thanks for sharing
Nice explanations, good technique sir.
Great sir thanks
This is awesome! Thank you!!
My corrective column is not working. And how do I hire you to teach me how to set up metrics for work?
Do let me know what issues you’re having with the corrective column.
Requesting for an excel file soft copy please.. great tutorial.. new sub here
Please use the below link to access the file
drive.google.com/drive/folders/1ANsXoa1idftrv4ZVraRW1Lma8IU5qM1g?usp=sharing
Great video...Thank you. I do have a problem that i hope you can help me with. When I add a formula to Column D from another sheet, it does not work as it should. Can you show me why?
Adding a formula to Column D should not cause any issues. Could you check whether Column D value is text or integer? In my example I have it as a text value to compare with " " (blank cell).
Thanks for sharing, my corrective value is not correcting for the total of the remaining days left, is only showing corrective vale only up the next working day and not the whole remaining days?
Hello ! Gret video.
Question. What if Days 8 to 10 are not zero for Actual Work? Then what does the calculation for Corrective rate work?
Thanks
If Days 8 and 9 are not 0 for Actual Work , it will continue to show the corrective rate of work. Once Day 10 is updated, you might get a #DIV/0! error for Required Rate. You can handle that error by modifying the formula in Cell J6 to --> =IFERROR((J4-J3)/J5,"")
Works great but I’m looking for a way to make changes in column C, and not have the original planned work end point change. My scope keeps increasing. Any suggestions?
The only issue I am facing that "corrective action' line is not appearing in the graph...What should I do....I have tried many times but unable to proceed
Are you not seeing the corrective line at all even after the data for the line is selected?
Thank you! just a question.. what if my initial data is from a pivot table?
😮
Hi, great video! Have you got a similar but for burndown?
Not yet!
Am not able to give the dotted lines and actual is showing until the end date which is incorrect representation
How can we do this in pivot chart?
Specifically, power pivot
I have planned and actual curves.. But somehow not able to write a measure to get the corrective curve
Could you please help?
Unfortunately I do not know how to get this to work with power pivots
Can you provide this excel sheet
Please use the below link to access the file
drive.google.com/drive/folders/1ANsXoa1idftrv4ZVraRW1Lma8IU5qM1g?usp=sharing
hi, it's not working for me
Could you please provide us with some additional details on the errors?