No more new formats may be applied in this worksheet

J

Jan Karel Pieterse

Hi Frakiexx,
How can I add more format capacity to my worksheet (I am using graphs)

By simplifying your formatting!

One way is to rationalise the fonts of your charts so you use as little
different font settings per chart element as you possibly can.

For this to work, you should uncheck the autosize option of the fonts:
rightclick chart area , select format chart area, font tab. Also, whilst on
that tab, set one font setting -name, size, bold, ...- for all chart elements.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top