Roger, I have an alternate solution that does not need the offset formula - if you can accept a chart approach. I anm not sure if it requires 2007 or not. This is a trick I developed by trial and error to allow the range of chart series to be dynamically adjusted without using offset formula. (...