Set position into a worksheet using vba
 

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

Thanks in advanced

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

Set position into a worksheet using vba
 

Thanks, it works fine.

"Jon Peltier" escribió en el mensaje
...
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