How many dynamic charts can I have in one Excel worksheet?

Tedd VanWagner August 10, 2011
Pinterest Stumbleupon Whatsapp

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.

  1. Tina
    August 13, 2011 at 5:24 am

    Thanks for the update, Tedd. Sounds like a weird issue, too.

  2. Tedd
    August 11, 2011 at 11:57 am

    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.

  3. Anonymous
    August 11, 2011 at 10:29 am

    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.

    http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

    Automatic Update of Charts when Adding Data
    http://www.eggheadcafe.com/community/aspnet/66/10108507/automatic-update-of-charts-when-adding-data.aspx

    Consolidating multiple worksheet to a single sheet in Excel
    http://tipsindeed.com/excel/consolidating-multiple-worksheet-to-a-single-sheet-in-excel.html