analysis of budget versus actuals

[connect1]

I hope someone can help.

I have a list of employees by name in 1 column, annual salary in the next column for this then split out on a monthly basis across the sheet for each month - per the approved budget.

I then have another sheet that is in the same format as above for the actuals for January to September.

Can someone please suggest the best approach, to see analyse the variances to budget. This could be due to a new joiner budgeted to start that has not, or due to a leaver that has left the business (not replaced) but is in the approved budget for the full 12 months.

Thank you,

[JeteMc]

If I am understanding what you are asking, then I would suggest a line chart as in the following Excel 2010 file.

BudgetvActual.xlsx