I am having an issue finding a work around for the limitation that data bars cannot use relative references. I would greatly appreciate the help.
This is an inventory tracker I have built for almost every item we have in stock.
Basically I need column E's data bar's maximum to be set to the corresponding cell in Column L. Of course since excel will not allow relative references for data bars, it will only reference the top cell for all rows.
The only work around I can find is setting a new conditional rule for each and every row. Given the insane number of items I am working with this is not a viable option.
Is there some sort of formula I can use to have my data bars reflect Column E's value compared to Column L's value relatively?
I have hidden the columns & rows unrelated to my issue.
excel example.png
Bookmarks