# Create and verify a linked budget

> Goal: create a working budget and check that changes reach the summary and the chart. Requirements: a blank board or the Budget page from Create a plan from a blank board. Use Data tables, not Plain…

Source: https://docs.vectorboard.app/en/complete-workflows/create-and-verify-a-linked-budget/ · COMPLETE WORKFLOWS

Goal: create a working budget and check that changes reach the summary and the chart. Requirements: a blank board or the Budget page from Create a plan from a blank board. Use Data tables, not Plain tables. The amounts are sample values in USD.

| Row | A: Item | B: Quantity | C: Price | D: Formula |
|---|---|---|---|---|
| 2 | Venue | 2 | 250 | =B2*C2 |

| Row | A: Item | B: Quantity | C: Price | D: Formula |
|---|---|---|---|---|
| 3 | Printing | 100 | 1.50 | =B3*C3 |
| 4 | Food | 20 | 18 | =B4*C4 |
| 5 | Equipment | 1 | 140 | =B5*C5 |
| 6 | Total |  |  | =SUM(D2:D5) |

1. Insert a **Data table** called `Budget`. Use row 1 for the four headers and add the sample rows.
2. Enter the formulas in D. Apply USD currency to C and D. Check D2=500, D3=150, D4=360, D5=140 and D6=1,150.
3. Add a page `Report` and another **Data table** called `Summary`, with the columns Metric and Value.

![Spreadsheet editing](https://assets.vectorboard.app/docs/fig/fig-868.webp)
*Write formulas with help*

4. In Summary, type A2=`Budget total` and B2=`=Budget!D6`; A3=`Spending limit` and B3=`1200`; A4=`Available` and B4=`=B3-B2`. Available should be 50.
5. Go back to Budget. Select the labels and totals of rows 2 to 5, choose **Create chart** and bars. Do not include the grand total as another spending category.
6. Save a version `Budget before changing food`. Change C4 from 18 to 20.

![Charts linked to the data](https://assets.vectorboard.app/docs/fig/fig-886.webp)
*Show a trend*

7. Check: Food=400, Total=1,190 and Available=10. The Food bar must change too.
8. Place the chart and Summary next to an explanation or inside a document. Export and open the report to check the delivered figures.

> **Expected result:** A single change shows up in the original table, the summary on another page and the chart. The example includes exact values so you can check the result instead of assuming success.

> **Important:** If Available is not 10, check the cell, the table name, the references and the numeric interpretation. Undo the change to return to the verified state, or restore the named version.