OWC10 Pie Chart Labels

Hello.

I'm working on ASP and OWC10 to generate graphics from a database. The graphics are working well except for the following issue. I can't locate the labels of the graphic outside the pie, the are positioned right in the center of the pie, and -of course- it looks terrible. Coould anyone help me with this issue? In the case, the labels can't be positioned outside the pie area, I would like to know if it's possible to put the labels in the legends area, -at the left of the graphic-. Thanks in advanced, and hope it works.

Jcaicedc
jcaicedcAsked:
Who is Participating?
 
MPDeveloperConnect With a Mentor Commented:
Hey jc,

I'm working as well with ASP and OWC10, (which annoys me more and more every day). I felt the same way about the pie chart and in OWC10 you cannot place the labels outside of the pie chart unless you want to manually position them.


As far as placing them in the legend - I'm not sure how you go about making your calculations, but I decided to do all of my own calculations in the ASP and then dump it to an array which I have OWC read - like this

'---- BEGIN ASP/VBSCRIPT ----

   chsp.Charts(1).setData c.chDimCategories, c.chDataLiteral, ARYcat

'---- END ASP/VBSCRIPT ----

If you are doing your own calculations, you can just through the totals, or the percentages at the beginning of the category label. Something like...

'---- BEGIN ASP/VBSCRIPT ----

ARYcat(1) = pieSliceVal & " - " & pieSliceLabel

'---- END ASP/VBSCRIPT ----


The last option, which I took, is just to change the background and foreground of the labels. I just took the background and make it white and turned the text black so that it at least showed up on the pie chart and looked decent. Heres the code I wrote for this...

'---- BEGIN ASP/VBSCRIPT ----

set dls = chsp.Charts(1).SeriesCollection(0).DataLabelsCollection.Add
dls.numberformat = ".#%"
dls.interior.color = "white"
dls.HasPercentage = True
dls.font.size = 8
dls.font.bold = true
dls.font.color = "black"
dls.HasValue = False

'---- END ASP/VBSCRIPT ----

I hope this helps you out a little.

Best of Luck,

Benny B.
0
 
jcaicedcAuthor Commented:
Thanks a lot MPD. Well, since there's no other way I will start immediately with manual working. See you soon!!

Jcaicedc
0
All Courses

From novice to tech pro — start learning today.