How To Create An Actual Vs Target Chart In Excel

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
In this post, I explain how to create an Actual vs Targets chart in Excel. This chart overlays the projected or goal numbers with the actual performance numbers realized for a time period.

The chart can be used to compare multiple targets, goals, budget amounts, forecast projections, etc. It can also be created as either a bar or column chart.
If you’d like to see the accompanying blog post on my website, you can find it at this link: https://www.excelcampus.com/charts/ac...

Additional Resources:
Column Chart That Displays Percentage Change in Excel - Part 1:    • Create A Column Chart That Shows Perc...  
Percentage Change in Excel Charts with Color Bars - Part 2:    • Percentage Change in Excel Charts wit...  
Column Chart That Displays Percentage Change - Part 3:    • A Column Chart That Displays An Inter...  

#MsExcel #ExcelCampus
00:00 Introduction
00:22 Charting Actuals vs. Targets
01:05 Start with Your Data
01:48 Create a Chart
02:25 Formatting the Bars in the Chart
04:57 Overlaying the Columns
05:33 Additional Formatting
10:25 Converting a Column Chart to a Bar Chart