Message: "No more new font available.."

[Shiji]

On an Excel sheet I needed to create a lot charts with the
same format but different data. I created one chart and
formated the way I wanted, then copied and pasted the
chart, then changed the data source.

It worked well at the beginning, but later it complained
saying "No more new font available..." then the program
quits.

Anybody knows what the problem is and how to solve the
problem?

Thank you!

- Shiji

 

[Debra Dalgleish]

Jon Peltier has some information on this issue in his Charting FAQ article:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon025

 

[Shiji]

Thank you, Debra! I will try turn off auto scaling.