I think Lee already suggested that, Glenn (see line #3 of post #2). I think it's the best compromise.

I have never undersood why MS has failed to make data bars etc. capable of using relative references.