Controlling Chart formatting

[AndrewL - ExcelForums.com]

Going mad - don't know if it is a general Excel chart problem o
specific to Macs (or my MAC?)

Various charts I have put together seem to change format at will
usually when I save the file or print it. Changes are usuall
restricted to font sizes of chart/data labels, sizes of text boxe
and sizes of pies. Not even consistent - for example a shee
containing 6 pies (printing on one page) will change the format an
display of 2 or 3 of the pies but not the rest even though all ar
derived from the same original so have the same formatting an
options

Any suggestions gratefully received

Apologies if this has been discussed here before

 

[Jon Peltier]

I've heard of this problem a lot, but I've rarely experienced it. I suspect it's because I
reformat practically every element in a chart. It seems that if you explicitly set many
formatting options in a chart, it is less prone to spontaneous changes. To prevent fonts from
readjusting, you could apply the suggestions on this page:

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

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