How can I set a default chart size?

  • Thread starter Thread starter Teece
  • Start date Start date
T

Teece

Hi,

I am making a spreadsheet with several embedded charts, of the x-y type.
Every chart that I create with the chart wizard is of a different size. I
could manually resize each chart but this is not the objective. Is there a
way to set a default chart size?

Thank You
Tom

(e-mail address removed)
 
Maybe this will help
Sub Macro1()
'
' Macro1 Macro
' Macro recorded by Jon Peltier
'
ActiveSheet.Shapes("Chart 1").IncrementLeft -58.5
ActiveSheet.Shapes("Chart 1").IncrementTop -57#
ActiveSheet.Shapes("Chart 1").ScaleWidth 0.8, msoFalse,
msoScaleFromTopLeft
ActiveSheet.Shapes("Chart 1").ScaleHeight 0.88, msoFalse,
msoScaleFromTopLeft
End Sub
 
Back
Top