Graphs moving

[SRHShelpdesk]

I have a user who is now using 2007. When updating a worksheet with graphs
created in 2003, her graphs will not stay in place. She saves the worksheet
but when she reopens it, the graphs have moved and resized. I'm thinking she
will have to recreate her worksheet in 2007 but we would like to avoid that
if possible.

 

[Don Guillett]

click on the chart>format chart area>DONT move and size
-
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[SRHShelpdesk]

when I right-click on the graph, and go to Format Chart Area, I don't have an
option for "Don't move and size".
I have Fill, Border Color, Border Styles, Shadow and 3-D Format. No option
for move and size under any of those.

 

[Don Guillett]

I went to 2007 and couldn"t find it either. I assume you have access to 2003
where you can do this. If not, send to me at the address below for a look .

 

[Andy Pope]

Hi,

To get the dialog to change move and size settings.
Select the chart, Chart Tools > Format > Size > dialog launcher (arrow
bottom right of group).
The dialog has the Move and Size settings.

Cheers
Andy