| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink in same sheet - positioning problem | Links and Linking in Excel | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
| wrong positioning of data in sheet after clearcontents() | Excel Programming | |||
| Recalculate sheet & Positioning text boxes | Excel Programming | |||
Linear Mode
