size of datalabels

A

Aros

Hi,
1. i am trying to reduce the font size of datalabels,
cause the values in my charts appears very closer.
this chart is a barchart type

2. how can i represent in a piechart the values in a
percentage form?

sorry by my very bad english :)

i have the Qimao Zhang's book but i don't find this
properties :-|

Gracias!
 
T

Thao Moua [ms]

Answers to your questions.

1)
set d=webchart.charts(0).seriescollection
(0).datalabelscollection.add
d.font.size = 5

2)
set d=webchart.charts(0).seriescollection
(0).datalabelscollection.add
d.HasPercentage = true
d.HasValue = false

Thao Moua
OWC Webchart Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
T

Thao Moua [ms]

Answers to your questions.

1. (assuming you have 1 datalabel on the series)
CS.charts(0).seriescollection(0).datalabelscollection
(0).font.size = 6

2. (assuming you have 1 datalabel on the series)
set d=CS.charts(0).seriescollection
(0).datalabelscollection(0)
d.hasValue=false
d.hasPercentage=true

Thao Moua
OWC Webchart Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
A

Aros

Thanks a lot!
-----Original Message-----
Answers to your questions.

1. (assuming you have 1 datalabel on the series)
CS.charts(0).seriescollection(0).datalabelscollection
(0).font.size = 6

2. (assuming you have 1 datalabel on the series)
set d=CS.charts(0).seriescollection
(0).datalabelscollection(0)
d.hasValue=false
d.hasPercentage=true

Thao Moua
OWC Webchart Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

.
Click to expand...
 
Top