Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Bug in VBA EXCEL 2007
Name:
vzbzdnov
Email (spam proof):
Email the originator of this post
Date:
Tuesday, January 02, 2007
Hits:
93
Discussion (Terms and Conditions):
This code displays clear percentage and hides balance on 3D Pie chart in EXCEL2003, but displays garbage in EXCEL2007, because ShowPercentage:=True no longer works Dim ch As ChartObject Set ch = Worksheets("Charts").ChartObjects.Add(10, 10, 210,210) With ch.Chart .SetSourceData Source:=Sheets("Allocation").Range("A1:C7"), PlotBy:=xlColumns .ChartType = xl3DPie With .SeriesCollection(1) .XValues = Sheets("Allocation").Range("A1:A7") .ApplyDataLabels ShowPercentage:=True End With End With Sheets("Allocation") looks like this: 1101 Product1 $2,197.99 1102 Product2 $5,731.24 1103 Product3 $9,613.70 1104 Product4 $6,053.07 1105 Product5 $6,177.96 1106 Product6 $3,700.14 1107 Product7 $3,765.61

Sponsored by the best FTP application on the internet: