ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   What is the meaning of "No new font may be applied in this workbo. (https://www.excelbanter.com/charts-charting-excel/46224-what-meaning-%22no-new-font-may-applied-workbo.html)

No New Font

What is the meaning of "No new font may be applied in this workbo.
 
When updating each of chart data series in a workbook, the message "No new
font may be applied in this workbook" appears prior to changing data series.
What did I do to prompt this message, how do I correct?

Jon Peltier

Your charts are probably set to use font autoscaling, which uses twice
the font resources as not autoscaling. In the font dialog, there's a
checkbox for Auto scale, which should be unchecked.

This is a pain to fix if you have enough charts to cause the warning,
but I have some VBA procedures on the following page to fix an existing
condition, and a registry hack to prevent it in the future. (Not prevent
it, really, but put off its occurrance for twice as long).

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


No New Font wrote:
When updating each of chart data series in a workbook, the message "No new
font may be applied in this workbook" appears prior to changing data series.
What did I do to prompt this message, how do I correct?



All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com