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

.
 

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

Top