We can see that most of the actual expenses are spent on transportation. Now, after a few modifications, the doughnut chart will look better.Therefore, a basic doughnut chart will appear.Next, from the All Charts tab, select Doughnut from the Pie chart section and press OK.Then, the Insert Chart window will pop up.Secondly, from the Insert tab, select Recommended Charts.Firstly, select the cell range B4:B10 and D4:D10 by holding the CTRL key and dragging with the mouse.Without further ado, allow us to demonstrate how to carry out these. Finally, we will select the doughnut chart from the pie chart section in Excel. After that, we will bring up the Insert Chart window. In the last step, we will create a doughnut chart to visualize the actual expense breakdown. Read More: How to Create Budget and Expense Tracker in Excel This will complete our vacation budget and the final output will look similar to this.To begin with, type the following formula in cell D5 and AutoFill the formula into the rest of the cells downward.Additionally, we will also use the fixed cell reference in our first formula. Moreover, we will use the Fill Handle to fill the formulas into the relevant cells. We will use the SUMIF and SUM functions in the second step to calculate the actual expenses and total value, respectively. Read More: How to Make Food and Beverage Budget in Excel Lastly, type the breakdowns of the expense groups in the lower table.Thirdly, type all the estimated values in the next column.Secondly, type the classification of the expense in the “Group” column.Firstly, type all the following fields in the Excel sheet.Then, we have the helper table to show the detailed expenses for the groups in the main table. The first table, which is the main budget table, consists of “Group”, “Estimated”, “Actual”, and “Difference” columns.
There will be two tables and four columns each. We will enter the required columns and fields in this first step. Lastly, we will create a pie chart to visualize the category-wise expense distribution.
Secondly, we will enter the estimated and actual values. There are three easy steps to create a vacation budget in Excel. Related Articles Step-by-Step Procedures to Prepare a Vacation Budget in Excel