Programmatically find out if Chart displays Percentages
 

Hi all,

I am trying to find out if a Chart has it's data labels showing Percentages
from VBA code.

Can anyone help me with this.

Thanks in advance.

Kind Regards,

Grant.

Programmatically find out if Chart displays Percentages
 

Example using the Immediate Window:

?ActiveChart.SeriesCollection(1).DataLabels.ShowPe rcentage
True

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Grant" wrote in message
...
Hi all,

I am trying to find out if a Chart has it's data labels showing
Percentages
from VBA code.

Can anyone help me with this.

Thanks in advance.

Kind Regards,

Grant.