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

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

Thanks, it works fine.

"Jon Peltier" <[email protected]> escribió en el mensaje
news:[email protected]...
> 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
>