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

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

" wrote:

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

On Aug 20, 2:56 pm, Barb Reinhardt
wrote:
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



" wrote:
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- Hide quoted text -

- 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