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

• #
• #excel
• #excel_campus
• #actual_versus_target
• #actual_vs_forecasted_chart_in_excel
• #actual_vs_planned_chart_in_excel
• #actual_vs_target_chart
• #actual_vs_target_chart_in_excel
• #actual_vs_targets
• #actual_vs_targets_chart_in_excel
• #advanced_chart_in_excel
• #excel_charts
• #microsoft_excel
• #target_charts_in_excel
• #target_vs_actual_chart
• #excel_charts_and_graphs_tutorial
• #excel_charts_and_graphs
• #excel_dashboard