using offset with charting

[bob farey]

how can I use the offset function to select the starting
row and ending row of a range I wish to chart. I have 100
rows but I wish to select any 10 consecutive rows to
chart, by, say, typing 7 into cell A1, so that the chart
displays rows 7 to 16.

thanks

 

[Andy Pope]

Hi Bob,

From a very recent post on the same subject.

Jon Peltier has a collection of examples,
http://peltiertech.com/Excel/Charts/Dynamics.html

As does Tushar Mehta,
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

Cheers
Andy

 

[bobf]

Hi Andy,
I can make this work for a single line chart, but my chart
has 4 lines on it. I can only get one line to chart as
more data is added. I must be missing something....

Bob

 

[Andy Pope]

You will need to define a dynamic range for the category labels and each
of the data series.