Planned vs Actual chart in Excel | With Corrective Path

Рет қаралды 41,119

Күн бұрын

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

Пікірлер: 44

@ExcelTipsVideos 4 жыл бұрын

Check out our Video on how to create Heat Maps in Excel: kzfaq.info/get/bejne/gKenn5l0l7jNh4E.html

@robertsalsa8823 3 жыл бұрын

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

@ExcelTipsVideos 3 жыл бұрын

@@robertsalsa8823 Hi Robert, Thanks for reaching out to me. I am, however, unable to assist you due to other commitments.

@robertsalsa8823 3 жыл бұрын

@@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

@selvarajukrishnan3581 11 күн бұрын

Sir, thanks for sharing.very helpful for me. Again thank you very much.

@franklinarguedas4832 2 жыл бұрын

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!

@ExcelTipsVideos 2 жыл бұрын

Thank you for your kind words

@gkane1870 3 жыл бұрын

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!

@ExcelTipsVideos 3 жыл бұрын

Thank you for your support....

@md.jahangiralam6447 Ай бұрын

thank you sir for excellent video.

@ExcelTipsVideos 14 күн бұрын

Welcome!

@ronaldpaglinawan4290 3 жыл бұрын

very helpful ! thank you very much

@ExcelTipsVideos 3 жыл бұрын

Glad it helped!

@robertlanden3451 Жыл бұрын

Thanks!

@souravtewari4597 7 ай бұрын

Thanks for sharing

@edmundtumaca2334 2 жыл бұрын

Nice explanations, good technique sir.

@mygaming584 Жыл бұрын

Great sir thanks

@carmenbrooks6583 Жыл бұрын

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?

@ExcelTipsVideos Жыл бұрын

Do let me know what issues you’re having with the corrective column.

@dondibart2106 2 жыл бұрын

Requesting for an excel file soft copy please.. great tutorial.. new sub here

@ExcelTipsVideos 2 жыл бұрын

Please use the below link to access the file drive.google.com/drive/folders/1ANsXoa1idftrv4ZVraRW1Lma8IU5qM1g?usp=sharing

@miltonmelgar745 2 жыл бұрын

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?

@ExcelTipsVideos 2 жыл бұрын

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).

@zincobest7 3 ай бұрын

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?

@YT-tt9rb 2 жыл бұрын

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

@ExcelTipsVideos 2 жыл бұрын

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,"")

@ckelly3224 2 жыл бұрын

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?

@jatinrawat786 2 жыл бұрын

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

@ExcelTipsVideos 2 жыл бұрын

Are you not seeing the corrective line at all even after the data for the line is selected?

@jeanyvestorres5946 Жыл бұрын

Thank you! just a question.. what if my initial data is from a pivot table?

@harfeljayhiolen8950 Жыл бұрын

😮

@arrrhaitch4563 3 жыл бұрын

Hi, great video! Have you got a similar but for burndown?

@ExcelTipsVideos 2 жыл бұрын

Not yet!

@vijaypandian1090 Жыл бұрын

Am not able to give the dotted lines and actual is showing until the end date which is incorrect representation

@rahulkalingeri1206 2 жыл бұрын

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?

@ExcelTipsVideos 2 жыл бұрын

Unfortunately I do not know how to get this to work with power pivots