Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: Max Number of Charts/Sheets in a workbook

    My workbook has multiple pages that contain multiple charts on them.
    After about 6 sheets, with about 16 charts each, i get the error:
    No More new fonts may be applied in this workbook.

    And I am unable to change the font for the headings of the charts.

    Is there any way around this ?

  2. #2
    Join Date
    Feb 2004

    Re: Max Number of Charts/Sheets in a workbook


    Select the chart.
    On the Format menu, click Selected Chart Area.
    Click the Font tab.
    Click to clear the Autoscale check box.
    Click OK.

    this should be able to let excel generate few more charts...
    rememer there is a internal limit of around 4000 font objects per workbook in excel2000


Posting Permissions

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