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?
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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks