im trying to use the data in the second column to show progress on close out of the issues in the first column; im having trouble 1) pointing to the number in the other cell to use as the data value and 2)each data bars' maximum could be unique will be different based on the reported amount, is there a way to do this using formulas?

Capture.PNG