Set position into a worksheet using vba

[Ricardo Mercader]

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

Thanks in advanced

 

[Jon Peltier]

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]

Thanks, it works fine.

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/
_______