Run-time error: Unable to get the count property of the DataLabels class

[TheWildAfrican]

Dear All:

I'm getting a run-time error each time I tried to execute the code below.

objChart.SeriesCollection(1).DataLabels.Font.Size = 7

objChart.SeriesCollection(1).ApplyDataLabels AutoText:=True, LegendKey:= _
False, ShowSeriesName:=False, ShowCategoryName:=False, ShowValue:=False, _
ShowPercentage:=False, ShowBubbleSize:=False

Has anyone encountered the bug before?

Thanks for your anticipated help.

Best,

TheWildAfrican

 

[Domenic]

Re: Run-time errpr: Unabble to get the count property of the DataLabels class

You'll need to apply the data labels before you trying setting the font size. Also, your code disables each label option. So no data labels will actually be applied.

 

[TheWildAfrican]

Re: Run-time errpr: Unabble to get the count property of the DataLabels class

Thanks Domenic Tamburino. Your response is much appreciated. So, if I place the lines below before setting the font, you think the code would work?

objChart.SeriesCollection(1).ApplyDataLabels AutoText:=True, LegendKey:= _
True, ShowSeriesName:=True, ShowCategoryName:=True, ShowValue:=True, _
ShowPercentage:=True, ShowBubbleSize:=True

You'll need to apply the data labels before you trying setting the font size. Also, your code disables each label option. So no data labels will actually be applied.

 

[Domenic]

Re: Run-time errpr: Unabble to get the count property of the DataLabels class

Which option or options do you want for your lables?

 

[TheWildAfrican]

Re: Run-time errpr: Unabble to get the count property of the DataLabels class

Thanks again for your response. First, I wanted to see if I'll get the run-time error. The error was fixed fixed after I applied the data label as you suggested. As for the options I'll like to use for the labels, I'll have to make some adjustments to see what looks best. Thanks again man!!

Which option or options do you want for your lables?

 

[Domenic]

Re: Run-time errpr: Unabble to get the count property of the DataLabels class

Sounds good.

Cheers!