Data Range

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

Will

My data range for my chart is =Charts!$A$4:$C$28
How would I change the formula so the chart would update
as I add data from line 29 down to say line 40.
I would change my range from A4:C28 to A4:C40, but don't
want all the null data points.
Thanks..........Will
 
For one possibility, check the Excel | Tutorials | 'Dynamic Charts'
page of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top