Chart update automatically

  • Thread starter Thread starter DaveR
  • Start date Start date
D

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?
 
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
 
Back
Top