Sizing Charts

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

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
 
Phil Hageman said:
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?
Click to expand...

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
 
Back
Top