Change source according to data entered in a template.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using third party software to enter data into a template. Things seem
to work fine, except I want to vary the source data for the chart in the
template according to how many rows of data have been entered from the third
party. Is there a way to do this??
 
try using a defined name for the source data
edit>name>define>mysourcerange>refers to
=offset($a$2,0,0,counta($A:$A),6)
 
Back
Top