Balance Graph in Excel: Make One With a Running Total

To make a balance graph in Excel, put dates and running balances in adjacent columns, select those columns, then choose Insert > Insert Line or Area Chart > Line. First calculate the balance after each transaction; the chart will then show how it changes over time. The steps below use Excel for Microsoft 365 on Windows and an example account balance.

What You’ll Need

Excel for Microsoft 365 on Windows, or Excel for Mac with similar chart options.
A list of dated transactions and an opening balance. Use positive amounts for money added and negative amounts for money taken out.
A worksheet with one row per date or transaction. If several transactions happen on the same day, you can use separate rows with the same date.

This guide treats a balance graph as a line chart of an account balance over time. If you mean a different kind of balance, such as comparing two categories or visualizing a scale, the chart type and data layout may differ.

Step-by-Step

Set up the columns. In row 1, enter these headings: A1 Date, B1 Balance, C1 Description, and D1 Change. Keeping Date and Balance next to each other makes it easy to select the chart data. Change means the amount added to or taken from the balance in that row.
Enter the opening balance. In A2, enter the date your records begin. In B2, enter the balance on that date, such as 1000. In C2, enter Opening balance. You can leave D2 blank or enter 0. For this example, the opening balance is $1,000 on January 1, 2026.
Enter each transaction on its own row. Starting in row 3, enter the date in column A, a short description in column C, and the signed amount in column D. For example, enter 250 for a deposit and -80 for a withdrawal. Use actual Excel dates rather than date-like text; if needed, select the date cells and choose Home > Number Format > Short Date.
Calculate the first new balance. With the opening balance in B2, the transaction change in D3, and the balance result in B3, enter =B2+D3 in B3. For the example, a $250 deposit after a $1,000 opening balance produces $1,250. This formula adds the latest transaction to the balance immediately above it.
Fill the calculation down. Select B3, then drag the small square at the lower-right corner of the cell down through the last transaction row. You can also copy B3, select the balance cells below it, and paste. Excel adjusts the references in each row. With a later -80 transaction, the balance becomes $1,170; after a -300 transaction, it becomes $870. Check the final result against your transaction list.
Put the rows in chronological order. The opening balance should come first, followed by transactions from oldest to newest. If you sort, select the full data range so descriptions and transaction amounts stay with their dates. Choose Data > Sort, sort by Date, and choose oldest to newest. Check that the opening-balance row remains first; do not sort it into the transaction rows as if it were an ordinary transaction.
Select the chart data. Select the date and balance headings and values together, such as A1:B5 for the four-row example. Since the columns are adjacent, this selection includes only the dates and balances, not descriptions or transaction changes. If you have more rows, extend the selection through the last date and balance.
Insert a line chart. Choose Insert > Insert Line or Area Chart > 2-D Line. A line chart is useful here because dates form a sequence and the connecting line makes the direction of the balance easy to follow. Excel should use column A for the horizontal date axis and column B for the plotted balance. On Excel for Mac, use the Insert tab and choose a Line chart; the ribbon layout and wording can differ slightly from Windows.
Give the graph a clear title. Click the chart title and replace it with something specific, such as Account balance by date. If the chart has no title, select the chart and choose Chart Design > Add Chart Element > Chart Title > Above Chart. A useful title tells readers what the numbers represent, rather than simply saying Balance.
Format the axes and balance values. If the vertical axis shows too many decimal places, right-click it and choose Format Axis, then adjust the number format. You can also format the balance cells by selecting column B and choosing Home > Number Format > Currency or Accounting. Use the same currency and decimal precision throughout. If dates appear as serial numbers, format column A as dates and check the chart axis again.
Check the finished graph. Confirm that the first plotted value matches the opening balance, that each movement follows the transaction list, and that the latest point matches the calculated ending balance. If the line moves the wrong way, inspect the signs in column D: deposits should increase the balance and withdrawals should decrease it. Save the workbook after checking the chart.

For the sample figures, the graph begins at $1,000, rises to $1,250 after the deposit, falls to $1,170 after the $80 withdrawal, and then falls to $870 after the $300 withdrawal. Those values are illustrative only. For real financial records, check transactions against the relevant account statements and terms; this guide is not financial, tax, or legal advice.

Common Mistakes

Entering every transaction as a positive amount. A withdrawal entered as 80 increases the running balance instead of reducing it. Enter outflows as negative numbers and inflows as positive numbers.
Plotting the transaction changes instead of the balance. The Change column shows individual deposits and withdrawals. The Balance column shows the accumulated result. Select Date and Balance for this graph.
Leaving out the opening balance. Without a starting point, the graph may begin at the first transaction and give an incomplete view. Include the starting balance as the first plotted value.
Sorting only one column. Sorting dates without moving the corresponding amounts can attach a transaction to the wrong date and corrupt every later balance. Sort the entire table range together.
Using text instead of numeric values. Entries such as a typed dollar sign, words, or a leading apostrophe can cause Excel to treat an amount as text. Enter a number, then apply currency formatting.
Choosing a chart that hides the timeline. A pie chart or a column chart with crowded labels can make a long sequence harder to read. A line chart is usually the clearest starting point for balance over time.

Tips

Use one row per transaction. This keeps the calculation traceable and makes it easier to find an entry that caused an unexpected balance. For multiple transactions on one date, repeat the date and enter each transaction separately.
Make the worksheet easier to scan. Select the data and choose Home > Format as Table. A table helps distinguish the headings from the entries. When adding rows directly below it, Excel commonly extends the table; check that new data is included in the chart.
Keep the graph focused. A concise title, readable date labels, and a currency-formatted vertical axis are usually enough. Avoid decorative effects that make small changes difficult to see.
Choose an appropriate time scale. A daily balance can look busy when there are many transactions. For a long period, use a chart with dates across months or years, or create a separate summary at a consistent interval. Do not mix daily and monthly totals without labeling the change in scale.
Preserve the data behind the chart. Keep the transaction list on the worksheet and use the chart as a view of those figures, not as the only record. When you add new transactions, check whether the chart range expands to include them.
Use a zero baseline thoughtfully. A vertical axis that does not start at zero can make modest balance changes look dramatic. Right-click the vertical axis, choose Format Axis, and review Bounds. For a general account history, a zero minimum is often easier to interpret when the values are positive; if balances can be negative, choose a range that shows both sides of zero clearly.

Troubleshooting

The chart is blank or missing points. Check that the balance cells contain numbers, not text, and that the selected range includes the values as well as the headings. If a cell is genuinely empty, decide whether the record is incomplete or whether a balance should be calculated there. Do not enter a made-up value just to make the line continuous.

The dates appear as numbers or in the wrong order. Select the date cells and choose Home > Number Format > Short Date. Then inspect the underlying entries: a date stored as text may not sort in calendar order. Re-enter it as a date if necessary, and sort the full table by Date from oldest to newest.

The line rises after a withdrawal. Check the sign of the transaction in column D and the formula in column B. A withdrawal should have a minus sign, and each balance should use the previous row’s balance plus the current row’s change. For example, with a $1,170 previous balance and a -300 change, the new balance should be $870.

The graph does not include new rows. Select the chart and choose Chart Design > Select Data to inspect the chart data range. Extend it to include the added dates and balances, or recreate the chart by selecting the updated range. If the source is formatted as an Excel table, add the rows directly below the table and verify that Excel has included them.

The chart shows Description or Change as a plotted series. Select the chart, choose Chart Design > Select Data, and check the series and horizontal axis labels. Remove any unwanted series, then set the date column as the horizontal axis labels and the balance column as the series. Alternatively, delete the chart and select only the two intended columns before inserting it again.

The graph is hard to read because dates are crowded. Widen the chart, reduce the number of displayed date labels through Format Axis, or show a shorter time period. Keep all underlying observations in the data even if the chart displays fewer labels.

Frequently Asked Questions

What type of chart is best for a balance over time?
A line chart is usually the clearest choice because it shows the order and direction of changes over time. A column chart can work for a small number of widely spaced reporting dates, but it may become crowded with many transactions.

Can I make a balance graph without transaction details?
Yes. If you already have dates and ending balances, put them in adjacent columns, select both columns, and insert a line chart. You do not need a running-balance calculation when the balance values have already been prepared.

Should deposits be positive or negative?
For the method in this guide, deposits and other additions are positive; withdrawals and other reductions are negative. Keep that convention consistent so the running-balance calculation works as expected.

How do I make the graph update when I add transactions?
Format the source range as a table with Home > Format as Table, then check that added rows are included in the chart. If the graph does not expand, use Chart Design > Select Data to update its range.

Can the balance graph show a negative balance?
Yes. The line chart can plot values below zero. If the vertical axis does not show the negative range clearly, right-click it, choose Format Axis, and set bounds that include the lowest and highest balances. A visible zero line can help readers distinguish positive from negative values.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.