Prev: Macro jumps to combobox
Next: Question about linking Access to Excel.
From: Chad on 18 Jul 2008 13:27
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).SeriesCollection(1).Points(199).DataLabel.Text
= "199"

That line works fine, but

ActiveWorkbook.Sheets(pChartSheet).SeriesCollection(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


From: Chad on 19 Jul 2008 12:58
I was able to figure it out, but I don't know the reason behind it. In the
data series properties I needed to select 'Show Labels' radio button. It is
strange that it would fail half way through a data series though.

Thanks anyways
Chad


 | 
Pages: 1
Prev: Macro jumps to combobox
Next: Question about linking Access to Excel.