using offset with charting

  • Thread starter Thread starter bob farey
  • Start date Start date
B

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
 
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
 
You will need to define a dynamic range for the category labels and each
of the data series.
 
Back
Top