Creating Actual Vs. Target Charts in Excel

If you work involves reporting the actual and target data, you may find it useful to present the actual values versus the target values in a chart in Excel.
For example, you can show the actual sales values versus the target sales values, or the satisfaction rating achieved versus the target rating.
There can be multiple ways to create a chart in Excel that shows the data with Actual Value and the Target Value.
In this video, I will show you two methods to create Actual Vs. Target Charts in Excel.
The first method uses only columns bars to show the difference by changing the width of the target and actual values.
The second method uses markers to create a marker for the target value and the actual value is shown as the bar.
Read More and Download the example file: trumpexcel.com...
Actual Vs Target Chart in Excel
Achieved Vs Target Chart in Excel
Actual Vs Planned Chart in Excel
Actual Vs Forecasted Chart in Excel
Free Excel Course - trumpexcel.com...
Paid Online Training - trumpexcel.com...
Best Excel Books: trumpexcel.com...
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: www.youtube.co...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@greaterdesigns1]

Deleting that secondary axis is absolutely key to this working!!! Good job for putting that in the video.

[@SpotlightImpact]

Cool! I didn’t realize that if you delete the secondary axis both series will comply with the primary axis. Thanks for the trick!! 🔥

[@saraparker184]

amazing! you get to the point quickly and explain everything clearly. thank you very much! 🙏

[@chethankodandarama1204]

Many Thanks for this ! My boss loved it and i got an appreciation !

[@anuanne502]

Sumit Bansal, I love how your videos are concise. Very informative. Thanks so much for Sharing your knowledge!

[@boofit1961]

Excellent tutorial, nicely paced, concise and exactly what i was looking for, thanks.

[@anelimrimo]

Great video, it help a lot with a work presentation.

[@adnanozkara3576]

Great

[@mwendasolomon9966]

Quite helpful. Thanks

[@hajasahib8943]

Thank you brother

[@alexrosen8762]

Very very useful! Thanks a lot :-)

[@sudhirkankal]

Great one!!!

[@canyonsgone]

can you use this chart if your numbers are formated as numbers instead of "percent"?

[@iftekharraju318]

very helpful...Thanks

[@Allmytravelz7072]

Omg, i have been waiting for these awesome charts!!!! You rock....but change ur name 😀

[@nightangel8087]

thank you..

[@nand19779]

I am looking for actual and target for both revenue and profit in a single chart. May be 2 bars per month - one for revenue and one for profit. possible?

[@siva301in]

Please help to find this.
Is there any excel format or tool if we give estimated time in sheet1 it should display resource list from sheet2 who will finish in the estimated time. If 5 is given should display A will finish in 4 hours B in 5 hours C in 6 hours...

[@aliabdo5898]

Is't possible to make the deference appear in the column?