Chart update automatically

[DaveR]

Sometimes I start a data list to chart, create a chart then add data and the
chart automatically updates as I add to the data list. The X axis grows with
each entry. Other times, I do what I think is the same thing but the chart
lays dormant. I actually have to manually update the series range. Nothing I
do seems to make it "automatic". Is there a way to make any chart (new or
existing) update automatically when dynamic data is involved?

 

[Andy Pope]

Hi,

The chart will update automatically if,
- you based the chart on a List (Table in xl2007)
- created and used a dynamic named range
- insert a row, before last row of chart data

Cheers
Andy