Readers like you help support MUO. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.
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.
2011-08-13 05:24:00
Thanks for the update, Tedd. Sounds like a weird issue, too.
2011-08-11 11:57:00
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.
2011-08-11 10:29:00
If you're running Excel 2003, define the source data as a List (datamenu). In Excel 2007, Lists were renamed Tables. In both cases, anyformulas, including chart series formulas, which reference the entire columnof a List or Table will update as the list or table adds or removes rows.http://peltiertech.com/Excel/Charts/ChgSrsFmla.htmlAutomatic Update of Charts when Adding Datahttp://www.eggheadcafe.com/community/aspnet/66/10108507/automatic-update-of-charts-when-adding-data.aspxConsolidating multiple worksheet to a single sheet in Excelhttp://tipsindeed.com/excel/consolidating-multiple-worksheet-to-a-single-sheet-in-excel.html