Possible to create a line chart to track progress towards a goal?

[Torus_Global]

Hi, I’d like to create a line chart to track financial goals for the month and year. Can this be done through an AT block/app?

For example, let’s say I start the month at $0 and by the end of the month my goal is to reach $5000. The chart will create a single straight line to show this “trajectory”…

Then, each day I enter my income and expenses (which feeds into a field representing “balance”, the chart then shows me if I’m on track…

See the image below for reference.

Can this be done inside Airtable? If so, how? Thanks in advance for any help.

[ScottWorld]

My guess is that you could create that sort of a chart with the Vega-Lite app (which can create all sorts of advanced charts & graphs), although I don’t have personal experience with the app:

Airtable Support

Vega-Lite chart app

The Vega-Lite chart app provides advanced customizability for charts. Fulfill all your reporting needs with control over the display of colors, spacing, and annotation on the parts of the chart.  L...