View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default How To Stop Chart Sizing With Cells?

Hi,

Yes.
xl2003: Right click chart area and pick Format Chart Area. On the Properties
tab is Object positioning,
xl2007: Select chart then via the ribbon, ChartTools Format Size
dialog launcher (arrow bottom right corner of group) Properties tab
object positioning

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Wayne" wrote in message
...
If I insert a text box into a worksheet, I have the option of stopping
it from resizing if I resize cells that are under it. I don't seem to
have the same option with a chart that I've copied and pasted on to a
worksheet. Is there a way to stop my chart sizing with the cells?