data range

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

Hello.
My data range is =Charts!$A$4:$C$28
My data however will extend down to row 40.
What could I change the formula to so the chart will
change automatically as I add data in row 29, 30, 31 and
so on. I think it would be some kind of COUNT function or
INDIRECT but not sure what to use.
Thanks........Will
 
Back
Top