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