Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following code fails in the next to last line with error statement,
"Select method of point class failed" If i use an integer rather than the variable, it works; however, I need to use the variable to paste the line to he most recent point. What am I doing wrong??? Sub drawline() ActiveSheet.ChartObjects("Chart 967").Activate ActiveChart.SeriesCollection(4).Select xxx = ActiveChart.SeriesCollection(4).Points.Count Range("X1").Select ActiveSheet.Shapes("Line 969").Select Selection.Copy ActiveSheet.ChartObjects("Chart 967").Activate ActiveChart.SeriesCollection(4).Select ActiveChart.SeriesCollection(4).Points(xxx).Select Selection.Paste End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fix a comment to a moving datum point in a line chart | Charts and Charting in Excel | |||
Line and Point in the same chart? | Charts and Charting in Excel | |||
how to produce horizontal line chart of point est & 95% ci's | Charts and Charting in Excel | |||
How do I get a value of a calculated point on an excel line chart? | Charts and Charting in Excel | |||
How to extend a single point into a line in a chart? | Charts and Charting in Excel |