Sizing Charts

[Phil Hageman]

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

 

[Nick Holway]

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

 

[Kristin]

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