Chart formatting issue (components in chart jumps around as data input changes)

[lumpa]

Hi Guys,

I'm having some trouble with the formatting of charts "jumping around" when I change the inputs.

I run a correlation and regression testing sheet where the data in the 30 charts I have constantly change based on what data I select. The data input is determined by named ranges so I never go in and change the formatting or data directly in the charts. This is working very well and I'm perfectly happy with the mechanics of the model.

However when changing the chart input data the formatting constantly jump around which forces me to manuall go through all the charts and move around a text boxes I have in each chart as well as the legend and even the chart plot area itself. Basically, is there any way I can "freeze" the different components so they dont jump around on the chart as I change the input data?

Any and all input very appreciated.

I'm running excel 2010 on windows 7.

Kind regards,
Magnus

PS. Long time since I visited, the forum looks very nice now!