Graph source data series value issue

A graphing issue:

e.g.

Series1 Values: =BU5:BZ5

This works but I need to determine the end of the range by adding a column count/index to the starting column. The end of my range might be BV5 or BW5 depending on the index value that needs to be added.

e.g.

Series1 Values: =BU5BU5 + column index to get new column ID)

It does not appear that calculations are allowed to dynamically change the column ID. Please give me an alternative method to change the series value range column specifier for the end of the range.

Thanks.

Hi,

Dynamic ranges are the way to go - I could explain, but others do it far better than I

http://www.ozgrid.com/Excel/DynamicRanges.htm

hth

dave