Chart updates using cell reference

[jwhprinter]

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

 

[Jon Peltier]

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$24)

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]

I took a while for me to wrestle with it but I finally got it to work as
desired. Jon...you are the guru! Thanks!