Budget vs actuals chart in Excel with variance
There is no built-in chart for budget vs actuals in Excel, but the need is so very obvious. With these hacks you can make it happen by creating a combo chart, making the line be no line and just markers then adding data labels of the variance by each budget amount.
I also show how to make any chart auto expand in Excel using Format as Table.
To download example workbooks, enter email here: https://www.xlconsulting-asia.com/soc...
00:00 Introduction
01:14 Change line to show markers
01:51 Add difference numbers on charts
02:39 Cleaning up chart
02:58 Make a chart that auto expands