Programmatically find out if Chart displays Percentages

G

Grant

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.
 
J

Jon Peltier

Example using the Immediate Window:

?ActiveChart.SeriesCollection(1).DataLabels.ShowPercentage
True

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Labeling on independently stacked line chart 0
Pie Chart percentage 1
Excel 2010 Data Labels options not saving 0
Pie charts - 0 values 2
adding percentages to stacked bar charts 1
Percentages in a pie chart 3
100% Stacked Column Chart Labels 3
Requesting help to generate progress reports in Excel ... 0

Top