Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All
I'm trying to align a rectangle (called mySpacer) with the Left edge of Point(x) in a SeriesCollection. The following line of code returns error 438 so I'm presuming the 'Points' object doesn't have a Left value. ActiveChart.Shapes("mySpacer").Left = ActiveChart.SeriesCollection(1).Point(x).Left Can you steer me in the right direction? (I've looked at Jon Peltier's site but can't see anything obvoius.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Format numbers from percentage points to basis points | Excel Discussion (Misc queries) | |||
ActiveChart.SeriesCollection(1).Points(3).Select ERROR | Excel Programming | |||
XL2002 - SeriesCollection.Index | Excel Programming | |||
xl2002: Position Picture in SeriesCollection | Excel Programming | |||
Obtaining the value of an ActiveChart.SeriesCollection(1).Points(2) | Excel Programming |