data range

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart SERIES OFFSET 3
data range referrences 28
Using a formula to determine variable rows in Chart 4
Data Range 1
Static Chart Data Range 2
One Chart, Same Data ranges, different source sheets 4
Chart Source Data 5
Can a value axis autoscale to something other than 0 for the min? 2

Top