View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default Set position into a worksheet using vba

How did you create the chart object? This allows you to define the position exactly:

Worksheets("Sheet1").ChartObjects.Add(100,150,300, 225)

where the numbers are left, top, width, and height of the chart object in points
with respect to the top left of the sheet.

For an existing chart, again you should adjust the chart object, which is the parent
object of the chart:

With ActiveChart.Parent
.Left = 100
.Top = 150
.Width = 300
.Height = 225
End With

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Ricardo Mercader wrote:

I created a chart as an object in a worksheet, but can't set the position
inside it.
Any help?

Thanks in advanced