How to Create an Actual vs Target Chart in Excel

If your 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.
In this Excel Tutorial you will learn 2 Actual vs Target Charts:
1. The first chart that we'll create uses a contrast in the Actual and Target bars to show whether the target has been met or not.
2. The second chart uses marker lines to show the target value. The actual values are shown as columns bars.

🔍 Key Moments in This Video:
00:00 Two (2) different Actual vs Target Charts
01:18 1st Actual vs Target Chart
03:18 2nd Actual vs Target Chart

🎬 LINKS to other videos:

🎁 SHARE this video and spread the Excel love.
Or if you're short of time, please click the 👍

#excel #excelcharts

[mellontrainingtutorials]

THANKS for watching! Don't forget to leave me a comment below to let me know if you enjoyed the video. Do you have any questions? Let me know and I'll do my best to answer you. Best wishes!