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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MPDeveloperCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.