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

    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
    Posts
    1

    Re: Max Number of Charts/Sheets in a workbook

    Hi,

    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

    Regards,
    AllRounder

Posting Permissions

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