| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cntl+f does not find data that I can see in chart | New Users to Excel | |||
| stacked bar chart with percentages | Charts and Charting in Excel | |||
| percentages in an excel pie chart | Charts and Charting in Excel | |||
| Bug in Rounding percentages of Bar of Pie chart | Charts and Charting in Excel | |||
| Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
Hybrid Mode
