Tip #2000-3: Make your Excel charts update dynamically
Editing the chart series
Click on the trendline in the chart. The series definition appears
in the formula bar. We have changed the previous absolute cell
references to our new dynamic range names.