Adding Values of Datalabels in Chart

[arvarr]

Hi
Is there any way via VBA that I can add up the values of the DataLabels in chart?

Thanks.

 

[SkipVought]

Hi,

Aren't the values of the datalabels, the values in your chart source data on a sheet?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[arvarr]

Hi Skip
Yes, you are correct, it is in the source data.
However, is there a code to retrieve the values directly from the chart?
Thanks.

 

[SkipVought]

Check out the DataLable object of the Point object of the Series object.

The DataLable object has several properties. I thin you'll find it there.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

http://msdn.microsoft.com/en-us/library/bb223732(office.12).aspx

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[arvarr]

Thanks Skip , All good now.
I was using datalabel.value instead of datalabel.text so it did not work the first time.
Thanks for all your help.