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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"DaveR" <(E-Mail Removed)> wrote in message
news:1931BF67-121F-4566-90B7-(E-Mail Removed)...
> 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?