Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Location
    Harrisburg, PA, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graphing Error in workbook

    I have a user who created a spread sheet with 67 graphs linked together to a common data set. The user ran into trouble when he created the 67th linked graph.
    QUESTION: Is there a limit to how many graphs can be added to an Excel document, and is there a repair or fix to this?

    Thanks for your time.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphing Error in workbook

    This is what xl2k online help says:

    Charts linked to a worksheet Limited by available memory
    Worksheets referred to by a chart 255
    Data series in one chart 255
    Data points in a data series for 2-D charts 32,000
    Data points in a data series for 3-D charts 4,000
    Data points for all data series in one chart 256,000
    Line styles 8
    Line weights 4
    Area patterns (screen display) 18
    Total area pattern and color combinations (color display) 56,448
    Pattern and color combinations (color printer) 56,448 (the actual number depends on your printer and its software)
    Page fields in a PivotChart report 256 (may be limited by available memory)
    Data fields in a PivotChart report 256
    Calculated item formulas in a PivotChart report Limited by available memory

    I guess the message is: increase resources or limit (Complexity of) charts.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    New Lounger
    Join Date
    Apr 2001
    Location
    Harrisburg, PA, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphing Error in workbook

    Thanks for your detailed explanation - It has been helpful.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •