Chart updates using cell reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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!
 
Back
Top