Sizing Charts

Is there a way to code in the size of charts on a
worksheet? I have to make an on-screen presentation and
need all the charts the same size.

What would the code be, and would I put it in the
worksheet object code?

Thanks,
Phil

"Phil Hageman" wrote in message
...
Is there a way to code in the size of charts on a
worksheet? I have to make an on-screen presentation and
need all the charts the same size.

What would the code be, and would I put it in the
worksheet object code?

try:

With ActiveChart.Parent
.Height = 150 ' alter number to suit
.Width = 220 ' alter number to suit
End With

Put it in once you've created the graph.

HTH

Nick

Hi Phil,
I've downloaded the JWalk Chart tools and use it all the
time. You can simply click a button that will make all the
charts on your worksheet the exact same size. It's great.
http://j-walk.com/ss/
Thanks,
Kristin
-----Original Message-----
Is there a way to code in the size of charts on a
worksheet? I have to make an on-screen presentation and
need all the charts the same size.

What would the code be, and would I put it in the
worksheet object code?

Thanks,
Phil
.