Dynamic scroll bar max limit

[sammy.peters]

I have a graph that is graphing from a dynamic range and wanted the
max limit to change with the size of the range
is that possible?
it seems like i cannot link it either to a cell or to a name range and
dont konw how else to do this.
thanks
sammy

 

[Guest]

If you are linking your series to a named range you need to enter

='Sheet 1'!NamedRange

Are you sure your range exists. Try CTRL G and enter the range name to have
it highlighted.

HTH,
Barb Reinhardt

 

[sammy.peters]

If you are linking your series to a named range you need to enter

='Sheet 1'!NamedRange

Are you sure your range exists. Try CTRL G and enter the range name to have
it highlighted.

HTH,
Barb Reinhardt





- Show quoted text -

you cant do that. cant have it linked to a range. it only wants a
variable. as a result i have to make a variable in the code that
equals the range value then set the upper limit to equal the variable
i figured it out.


thanks a lot though
sammy