Excel Pro Tips: Create Perfect Sales vs. Target Graphs

Crafting an Effective Actual vs. Target Bar-in-Bar Chart in Excel

Discover how to craft an insightful actual vs. budget chart using the bar-in-bar technique in Excel. Learn to highlight targets and actuals for easy analysis of goal achievement. Unveil the power of secondary axes for adjusting bar widths separately and ensure aligned scales for precise comparison.

Download link to the Excel file used in the video: https://drive.google.com/uc?export=download&id=13CnZJX9xNOa04FL0kSFRggLiq74eQ5ot

0:00 - Intro
0:51 - Create the basic chart
1:28 - Place one series on a secondary axis
2:45 - Fixing the axis
3:34 - Formatting the chart
5:36 - Add the data labels

Видео Excel Pro Tips: Create Perfect Sales vs. Target Graphs канала RBX Excel videos