Positioning a char in a sheet
 

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

Positioning a char in a sheet
 

Have you tried the "Top" and "Left" properties ?

How is the position determined ?

Tim

--
Tim Williams
Palo Alto, CA


"Rui Álvares" wrote in message
...
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

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