Fix chart position

[PaulioH]

Hi there!

I have a user who has created a spreadsheet and wants to fix the charts in a particular position.

When she places them in one position and saves the spreadsheet they appear to have moved the next time she opens the spreadsheet.

Is there any way to fix them in a certain position without having to protect the worksheet?

Thanks,

Paul :D

 

[PaulioH]

Been browsing around on Google and still can't find anything. Can anyone help please?

Thanks

 

[mgm05267]

Hi PaulioH,

After placing the charts,
go for properties of the chart
Format--> Size & Properties, in properties tab, select "Don't move or size with cells", & say OK.

Now you charts are fixed.... they won't move.

While placing a new chart itself, if you perform this... it will be better.

Regards,

MGM

 

[PaulioH]

Excellent! Just tested it out on a few and it's working a treat.

Thanks for your help!