Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Raul -
Create it using ChartObjects.Add, not Charts.Add: Dim MyChart as Chart With ActiveSheet Set MyChart = .ChartObjects.Add(100,100,350,275).Chart '' (left, top, width, height in points) End With - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Raul wrote: Can anyone tell me how to specify the size and the location of a chart embedded in a worksheet? I can create the chart programmatically but I have to manually move the chart to the desired location. The chart gets created on the desired worksheet but not near the desired cell. Thanks, Raul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
size an embedded word doc in Excel | Excel Discussion (Misc queries) | |||
Retaining Embedded Chart size when columns under it are hidden/add | Charts and Charting in Excel | |||
reducing size of multiple embedded graphics | Excel Discussion (Misc queries) | |||
size of embedded object | Excel Discussion (Misc queries) | |||
Size and location of chart | Excel Programming |