Is there a limit to the number of dynamic charts you can have on one worksheet? I have an Excel worksheet that has 27 charts on it, but I can only get the first 3 to automatically update.
Thanks for the update, Tedd. Sounds like a weird issue, too.
Hi and thanks for your help. Actually I discovered that any name I
defined that started with the letter "C" didn't work (go figure). After
I figured that out everything stared to work just fine.
If you're running Excel 2003, define the source data as a List (data
menu). In Excel 2007, Lists were renamed Tables. In both cases, any
formulas, including chart series formulas, which reference the entire column
of a List or Table will update as the list or table adds or removes rows.
Automatic Update of Charts when Adding Data
Consolidating multiple worksheet to a single sheet in Excel