Excel Chart Resizing problem

[VBABeginner1996]

Hi guys, I recently converted to office 365 from 2010 and had a problem when I was resizing one of my Excel charts. Previously (on Excel 2010) I was able to change the width from say 5.45cm to 5.50cm without the height changing (say it was at 10cm). But with office 365 when I change the chart width, the height also changes by a couple of increments, say from 10cm to 10.04cm. Is there anyway I can make it that when I change the chart width, the chart height will stay the same and vice versa?

Kind Regards

 

[pgc01]

Hi

In the the Format Area dialog, in the Size panel, uncheck the "Lock aspect ratio" box.