Sizing of Graphs

[Vijay Anand]

Hi, I have Graphs which are autopopulated via VBA.
I managed to snap the generated graphs by following code which was given by Andrew....( Thanks Once again to him ).....

Sub Test()
Charts.Add
With ActiveChart
.Location Where:=xlLocationAsObject, Name:="Sheet1"
End With
With ActiveChart.Parent
.Top = Range("B10").Top
.Left = Range("B10").Left
End With

But Now I need to size the graphs...
They appear different on differernt monitors...

That is the lower corner of the graphs should also be snapped to a particular cell...
Pl help me with the VBA codes....

Thanks & Regards,

Vijay anand.R

 

[venkat1926]

the sizing of the graphs is trichy. What i do is create(not writing ) a macro and sixing the graph to my liking and slighly modify the macro so that it will be general