# How to Make a Budget Line Graph in Excel

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.

## 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.

### 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.

### 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.

### 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.

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

### 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.

• 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.

## 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.

## Related Articles

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

5 Excel Hacks You Never Knew