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" wrote in message
...
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?