I found the solution: You can click on the chart - select "Format" at the
top - click on the Size options and choose to have the chart not change when
cells are changed. Thanks!

"Don Guillett" wrote:

What I offered apparently applies to shapes and NOT charts. The only thing I
can suggest is to move the chart out of the area or to a separate chart
sheet. Also, look here.
http://peltiertech.com/Excel/Charts/index.html

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JAbels001" wrote in message
...
I have Office 2007 and I cannot find those options. Under "Layout" there is
a
properties button but it does not give those options, only allows me to
name
it...?

"Don Guillett" wrote:

Change the properties to NOT move and resize

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JAbels001" wrote in message
...
I have Office 2007 and everytime I hide a column of cells or two the
graph
that is overlapping those columns shrinks. How can I avoid this?