2007 Charts not retaining formatting

[Brazell]

We have a spreadsheet that we have put together with a number of calculations
and charts. Several scheets have two charts on it with the data and some
comments. The system keeps changing some of the chart formatting such as
label sizes, color or even the size of the whole chart. This can happen when
we get ready to print several sheets or even save the file exit Excel and
reopen the file. It seems to have a lot of loose ends with things just
happening to the formats in the file. This was a new spreadsheet created as
a 2007 Macro Spreadsheet. (We had to use a custom function since Excel does
not have an Interpolate function).

 

[ShaneDevenshire]

Hi,

Sorry I can't help with the formatting, but although Excel does not have a
function call interpolate you might be able to use the TREND function to
accomplish the same thing.