Offset function to set ranges for charts

  • Thread starter Thread starter Pele
  • Start date Start date
P

Pele

I used the OFFSET Function in Excel to create a dynamic
range i.e. the range size changes. I checked the dynamic
nature of the range being created by the OFFSET function
and it works well.

The problem is I am trying to use the cretaed range in a
chart for plotting the specified data points and I am not
being successful. If I enter the OFFSET function in
the "Source Data" of the Chart, it is not accepted. I even
went as far as to name the range refered to by the OFFSET
function, but then I didn't know how to use a named range
in a Chart's "Source Data".

Can anybody help with this problem.

Pele
 
Back
Top