View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Dynamic cell ranges in charts

Of course. For example, take Shane's suggestion from your last post, and
replace various parameters with cell addresses or names:

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A$1:$A$100) ,1)

becomes for example

=OFFSET(Sheet1!$A$1,Sheet1!$C$1,Sheet1!$D$1,Sheet1 !$F$1,Sheet1!$G$1)
=OFFSET(Sheet1!$A$1,Sheet1!RowOffset,Sheet1!ColOff set,Sheet1!NumRows,Sheet1!NumCols)
etc.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Harold Christian" wrote in
message ...
Hi,

I have set up a number of named cell ranges which plot ok in the chart,
but
now I want make global changes in the cell ranges without having to modify
them in the "Refers To" box. I am using Excel 2007. Can I use Named cells
within the Refers To box, ie. calling the new max and min cells and
establishing the range that way?