View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_9_] Jon Peltier[_9_] is offline
external usenet poster
 
Posts: 146
Default Positioning a char in a sheet

You need to specify the .Top and .Left properties of the chart's parent ChartObject.

With ActiveChart.Parent
.Left = 100
.Top = 100
End With

or

With ActiveSheet.ChartObjects(1)
.Left = 100
.Top = 100
End With

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

Rui Álvares wrote:

Hi,

My dificult is to positioned a chart in a determined position in a sheet.
I know the IncrementLeft and IncrementTop functions, but don't solve my
problem.
How can I do that?


Thanks in advance

Rui