Dynamic charts:
http://peltiertech.com/Excel/Charts/DynamicCharts.html
Your offset formula for X ("myXValues") would be
=INDIRECT("Sheet1!A"&Sheet1!$A$23&":A"&Sheet1!$A$2 4)
and for the various Ys would be
=OFFSET(myXValues,0,1)
where you use 1 for column B, 2 for column C, etc.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"jwhprinter" wrote in message
...
I have a multiple charts that plot data in A1:Z20. Column A is always the
x-axis. Columns B-Z represent different charts. Sometimes I want to see
all
20 rows of data, but sometimes I want to choose only a few rows (to zoom
in)
and plot only a few rows...say 8-14. I'd like to be able to put 8 in cell
A22 and 14 in cell A23 and have all charts reference those entries and
update
to show only data in cells 8-14. Is it possible? thx - jwhprinter