00:00If you want to impress someone with your Excel skill, prepare a budget versus actual chart
00:05that looks something like this.
00:07Ready to learn?
00:08Let's go.
00:09First select the month budget and the actual column like this, then you go insert, and
00:14under charts, you're going to insert a bar chart that looks something like this.
00:19Now reposition and resize that bar chart.
00:23Now to overlap the two bar chart together, right click on the orange bar chart here,
00:28click on format data series, and then you're going to select secondary from this selection
00:33here, and you can see that those two bar chart overlap on top of each other.
00:38Next to align the y-axis, you're going to choose the highest value among these two y-axis here.
00:4390,000 seems to be more higher than the 80,000, so right click on the 80,000, and then go say
00:49format axis, and you're going to change this maximum value to 90,000 like this, and hit
00:55enter, and this should look similar to this y-axis here.
01:00Now to make the bar chart stand out from each other, you're going to make one of the bar
01:04chart larger than the other one.
01:07So you're going to right click on the blue bar chart, format data series.
01:11In here on the gap width, you're going to change this to at least 60% so that you can
01:15actually see the difference between budget and actual bar chart.
01:19Next to include the difference column on your bar chart as a data label, first you're going
01:24to right click on the orange bar chart here, and you're going to say add data label, and
01:30this will show the orange value as a data label here.
01:33Now to change this into your difference column, right click on your data label like this, format
01:40data labels, and in here you're going to select values for cell, and you're going to click
01:46this guide, this button here, and select the difference column like this, and hit enter
01:51once and twice, and then after that you should see two values on your data label.
01:56Now to remove the remaining one, you're going to remove value, and basically remove show leader
02:03line like this, and then close that pop-up window on the side.
02:08And to make that label a bit more obvious to read, you can basically go to home when the
02:13dial label is selected, and change this fill color to be yellow, and maybe change the font
02:18color to be red, so that they are a bit obvious to see.
02:21And to seal the deal, I'll remove the chart border, add the chart title as budget vs actual,
02:28then remove chart horizontal lines, remove both y-axis, and then finally change the color
02:35color for the budget bar chart to be light orange.
