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/socials.html

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

Видео Budget vs actuals chart in Excel with variance канала David Benaim