Charts with a data source which has a variable dynamic range

[Tony29]

I have a large 2D array of data with 'date' in one of the columns as a common
charting key for all other columns in the array. For different reasons, I
might want to look at only a subset of the data on a chart - perhaps a subset
of the rows (based on a date range), and/or a subset of the columns (based on
including/excluding columns from the chart). I want to do this dynamically,
ie. perhaps by changing values in some reference cells which point to the
data in the array to be included in the chart, rather than editing the data
source(s) within the chart. With such a dynamic feature, I can design and
click buttons which will vary what is seen in the chart without editing the
chart. How do I do I specify a chart's data source in a dynamic way?

 

[JE McGimpsey]

I have a large 2D array of data with 'date' in one of the columns as a common
charting key for all other columns in the array. For different reasons, I
might want to look at only a subset of the data on a chart - perhaps a subset
of the rows (based on a date range), and/or a subset of the columns (based on
including/excluding columns from the chart). I want to do this dynamically,
ie. perhaps by changing values in some reference cells which point to the
data in the array to be included in the chart, rather than editing the data
source(s) within the chart. With such a dynamic feature, I can design and
click buttons which will vary what is seen in the chart without editing the
chart. How do I do I specify a chart's data source in a dynamic way?

Hard to tell exactly what you're thinking about - e.g., do you want to
use buttons or "some reference cells"?

One place you might get some ideas is Jon Peltier's site:

http://peltiertech.com/Excel/Charts/Dynamics.html