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.

click on the chartformat chart areaDONT move and size
-
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SRHShelpdesk" wrote in message
...
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.

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" wrote:

click on the chartformat chart areaDONT move and size
-
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SRHShelpdesk" wrote in message
...
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.

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 .

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SRHShelpdesk" wrote in message
...
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" wrote:

click on the chartformat chart areaDONT move and size
-
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SRHShelpdesk" wrote in message
...
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.

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

SRHShelpdesk wrote:
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" wrote:


click on the chartformat chart areaDONT move and size
-
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SRHShelpdesk" wrote in message
...

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.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info