Bill -

(Sorry for the delay)

Having used Excel 97 exclusively until very recently, I'd never seen
that Properties tab in the Format Chart Area dialog. Thanks for
teaching an old dog a new trick.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Bill Koran wrote:
Jon,

That's what I remembered, too, but I tested before I posted. What I said
was true for both Excel 2000 and 2002.

--Bill


"Jon Peltier" wrote in message
...

Bill -

Don't forget, you have to Shift-Click on the chart first, to select the
chart object. It's the chart object that has the Properties tab in its
Format dialog.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Bill Koran wrote:

Right-click on the ChartArea (just inside the chart border), and select
"Format Chart Area". On the "Properties" tab, change the selection

under

Object Positioning to get the behavior you want.

--Bill

"SpeeD72" wrote in message
.. .


Hi guys..

I have a tabel with aprox 50 rows, and i have to hide
some of them (when valeu = 0). When i do this the graph
that i have in "front" of this rows shrinks!!!

How can i freeze the Graph??? Can i give "give" a fixed
size to the graph, via macro, after o hide those rows???

I hope i made my self clear... :-)

Thanks a lot!

SpeeD72