arc90 lab | tools: Link Thumbnail
Excel Help Forum
ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 11-21-2005, 01:25 PM
jwhprinter
Guest
 
Posts: n/a
Chart updates using cell reference

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
Reply With Quote
  #2  
Old 11-21-2005, 01:40 PM
Jon Peltier
Guest
 
Posts: n/a
Re: Chart updates using cell reference

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



Reply With Quote
  #3  
Old 11-21-2005, 04:15 PM
jwhprinter
Guest
 
Posts: n/a
Re: Chart updates using cell reference

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

>
>
>

Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


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

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 05:15 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0