Chart updates using cell reference

#1 11-21-2005, 01:25 PM

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

#2 11-21-2005, 01:40 PM

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" <jwhprinter@discussions.microsoft.com> wrote in message
news:A3994FC2-9058-46E6-A0EC-99B846E7C875@microsoft.com...
>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

#3 11-21-2005, 04:15 PM

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!

"Jon Peltier" wrote:

> 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" <jwhprinter@discussions.microsoft.com> wrote in message
> news:A3994FC2-9058-46E6-A0EC-99B846E7C875@microsoft.com...
> >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
>
>
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)