View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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.