Set position into a worksheet using vba

  • Thread starter Thread starter Ricardo Mercader
  • Start date Start date
R

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
 
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/
_______
 
Thanks, it works fine.

Jon Peltier said:
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/
_______
Click to expand...
 
Back
Top