Controlling Chart formatting

  • Thread starter Thread starter AndrewL - ExcelForums.com
  • Start date Start date
A

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
 
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/
_______
 
Back
Top