Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I am trying to write a chunk of code that adds labels to my XY chart. Basically I code is very simple ActiveWorkbook.Sheets(pChartSheet).SeriesCollectio n(1).Points(199).DataLabel.Text = "199" That line works fine, but ActiveWorkbook.Sheets(pChartSheet).SeriesCollectio n(1).Points(200).DataLabel.Text = "200" fails with the falling error "Runtime Error 1004" My source data has 215 entries so, 1-199 works fine, but 200 + fails. Any ideas why? Thanks Chad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to change position of chart labels on line chart | Charts and Charting in Excel | |||
Adding labels to a bubble chart other than the X, Y or Z values | Excel Discussion (Misc queries) | |||
Pivot Chart - X-axis labels when adding data | Charts and Charting in Excel | |||
Adding labels to a waterfall BAR chart | Charts and Charting in Excel | |||
adding amounts according to labels | Excel Worksheet Functions |