I’m trying to create a list of 'completion bars’ or ‘progress bars’ using data bars for a savings budget. So for example:

A1 changes in value

The flowing cells have set goals:

A2: 200
A3: 400
A4: 700

The cells next to them show the percentage of completion (how much saved up in A1 towards the goal amount):

B2: 0-100%
B3: 0-100%
B4: 0-100%

Rules:

B3 won’t start to fill until B2 is 100% full (which completes when A1 is at 200). B3 will then start to fill, reaching 100% completion when A1 is at 600 in this instance.

It’s basically so that once one goal is complete the bar will fill up and the next one down on the list will then start to fill after and so on.

I just want a simple formula with direct references so that I don’t need to keep re-conditioning data bars, setting the minimum and maximum numbers manually and having to calculate and change formulas every time I change the value of A2/A3/A4.

Hope someone can help - my brain is fried!

*UPDATE*

To make things simpler, forget I even want a data bar, can someone just work out the formula so that B2/B3/B4 shows the percentage from 0 to 100. That way I can just create a data bar myself with minimum value 0 and maximum value 100.