dynamic ranges for charting
 

I saw another post with a similare title, but there was not enough info in
there to tell me if I am trying the same thing.

I want to have a column of data. Depending on the values in the column, I
will automatically calculate start and end rows for the data I want to
graph. If I paste in a new set of values, my formula to calculate the start
and end would automatically update and I would lkike the chart to
automatically update too.

I was able to create a single cell with an OFFSET() statement that
determines the position and height and width of my data to be graphed. When
I created a graph of that cell it did some crazy things, not just graphing
that singel value. So I think I'm on the right track trying to use OFFSET()
or ADDRESS() or something like that.

Thanks...

dynamic ranges for charting
 

Hi,

Try these explanations of dynamic ranges in charts.

See here for details on dynamic ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html

You need to define the OFFSET formula as a named range rather than in a
cell. Then the chart uses the named formula to plot.

Cheers
Andy

Bill Brehm < wrote:
I saw another post with a similare title, but there was not enough info in
there to tell me if I am trying the same thing.

I want to have a column of data. Depending on the values in the column, I
will automatically calculate start and end rows for the data I want to
graph. If I paste in a new set of values, my formula to calculate the start
and end would automatically update and I would lkike the chart to
automatically update too.

I was able to create a single cell with an OFFSET() statement that
determines the position and height and width of my data to be graphed. When
I created a graph of that cell it did some crazy things, not just graphing
that singel value. So I think I'm on the right track trying to use OFFSET()
or ADDRESS() or something like that.

Thanks...



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

dynamic ranges for charting
 

Thanks for the tips. I think i'll be able to go from here.

"Andy Pope" wrote in message
...
Hi,

Try these explanations of dynamic ranges in charts.

See here for details on dynamic ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html

You need to define the OFFSET formula as a named range rather than in a
cell. Then the chart uses the named formula to plot.

Cheers
Andy

Bill Brehm < wrote:
I saw another post with a similare title, but there was not enough info
in there to tell me if I am trying the same thing.

I want to have a column of data. Depending on the values in the column, I
will automatically calculate start and end rows for the data I want to
graph. If I paste in a new set of values, my formula to calculate the
start and end would automatically update and I would lkike the chart to
automatically update too.

I was able to create a single cell with an OFFSET() statement that
determines the position and height and width of my data to be graphed.
When I created a graph of that cell it did some crazy things, not just
graphing that singel value. So I think I'm on the right track trying to
use OFFSET() or ADDRESS() or something like that.

Thanks...

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info