How to Make a Budget Line Graph in Excel

Last updated: October 12, 2022
Get FREE Advanced Excel Exercises with Solutions!

This tutorial will demonstrate how to make a budget line graph in excel. A line graph is a statistical graphic to highlight the numerical proportions of a dataset. A budget line graph illustrates the proportion of expenses of each budget category compared to the total budget. This will help you reduce your unnecessary expenses and save the money for a better future or use the money to do more important things. Have a quick look through the article to learn how to make a budget line graph in excel and have a better future.


Download Practice Workbook

You can download the practice workbook from here.


Types of Line Graphs In Excel

In Excel, while making line graphs, you will find some types of options. Here, I am describing each type of them.

  • Line: You will use this type to show trends over time for large datasets.
  • Stacked Line: This graph will show how parts of the whole dataset change over time. Here, the points will not intersect and it makes cumulative points for each row.
  • 100% Stacked Line: It shows the proportion of the contribution to the trends and it scales the line so that the total becomes 100%. So, it will make a straight line at the top.
  • Line with Markers: It also shows trends over time but it marks the data points.
  • Stacked Line with Markers: It is the same as the stacked line chart but it marks the data points in it.
  • 100% Stacked Line with Markers: It is also the same as the 100% stacked line but in addition, it shows the data points in it.

Step-by-Step Procedures to Make a Budget Line Graph in Excel

We’ll use a sample dataset overview as an example in Excel to understand easily. If you follow the steps correctly, you should learn how to make a budget line graph in excel on your own. The steps for making a budget line graph are as follows:


Step 1: Setting Budget Categories

In this case, our goal is to arrange a dataset with proper budget categories. For instance, we have a dataset of different cost options named the Categories in Column B. We’ll use a sample dataset overview as an example in Excel to understand easily. The steps are as follows.

Catagorize Costs to Make a Budget Line Graph in Excel

Read More: How to Make a Household Budget in Excel (2 Smart Ways)


Step 2: Inserting Budget Amounts

Now, we want to enter the budget amounts in excel to make the line graph chart. In this case, we have the Amount in Column C. Without the amounts, the graph won’t be that effective. So, we have to insert the proper budget amounts to get a proper graphical line. The steps are as follows.

Inserting Cost Amounts to Make a Budget Line Graph in Excel

Read More: How to Create a 50-30-20 Budget Spreadsheet in Excel


Step 3: Formatting Budget Table

After inserting the budget categories with amounts, the table can be easily formatted if needed. While making a line graph it is very common to need formatting. We have to manually click on the cell in Column B or Column C, you want to change and then insert the new value in it. We have made changes in the cells C6, C8, C9, and C10 in the following image.

Formatting Data to Make a Budget Line Graph in Excel

Read More: How to Create a Personal Budget in Excel (With Easy Steps)


Similar Readings


Step 4: Inserting Budget Line Graph

Our main goal of this article is to insert a budget line graph in excel. This budget line graph will show you in which categories you are using the most money. This will help you to understand whether you need to pay that amount of money or reduce it for a better good. After having a proper dataset, now we will insert the budget line graph by following the below steps.

  • Firstly, go to select the table > Insert > Insert Line or Area Chart > 2-D Line options.

Inserting Budget Line Graph to Make a Budget Line Graph in Excel

  • After that, the following result will come on the display screen.

Result to to Make a Budget Line Graph in Excel

Read More: How to Do Budgeting and Forecasting in Excel (2 Suitable Ways)


Step 5: Editing Budget Line Graph

Now, if we need any changes in the budget line graph, we can edit the graph anytime by following the below steps.

  • First, go to select the chart > Chart Design options and select the desired chart accordingly.

  • Next, the following result will come on the display screen.

Data Labelling to Make a Budget Line Graph in Excel

  • Now, the following result will come on the display screen.

  • Moreover, go to the Chart Elements > Axis Titles > Primary Horizontal and Primary Vertical options.

  • Finally, the following result will come on the display screen with proper axes titles.

Showing Final Result to Make a Budget Line Graph in Excel

Read More: How to Make a Budget Constraint Graph on Excel


Things to Remember

  • In the case of making a budget line graph, the most important factor is to categorize the cost sections and insert the amount properly. That’s why formatting before or after creating a chart is very useful in this case.
  • When inserting a budget line graph, make sure to select the line graph option properly. You can anytime format the line graph by going to the Format Cells option.
  • The Data Labels and Axis Titles options play a very significant role in this case. Otherwise, the graph becomes hard to understand.

Conclusion

Henceforth, follow the above-described methods. Hopefully, these methods will help you to make a budget line graph in excel. We will be glad to know if you can execute the task in any other way. Follow the ExcelDemy website for more articles like this. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our best to solve the problem or work with your suggestions.


Related Articles

Zehad Rian Jim
Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo