Adding custom datalabels in OWC scatterplot

**magnusharju** · 08-29-2012, 03:44 AM

Hi!

I am using Microsoft OWC 11.0, I have created a userform and added the graph object. Everything works great but managing the datalabels.

Here's the code im using to create the graph object:

Please Login or Register  to view this content.

By adding the datalabels collection, I get the labels which is refering to the values I have assigned to series1. However, my problem is that I can't find a way to assign my own values to these datapoints. I have tried 2 possible solutions.

possible Solution 1, which also makes most sense to use, is using the chDataLabels reference in the SetData object. I have tried all the options given in the section hinglighted with the "?" and they all seems to be relating to other graph types. If this the way to accomplish the labelschange, then what should I use as the first argument?

possible Solution 2: The labels series can be changed easily by using the DataLabelsCollection, but this will only allow you to change the collection attributes such as font size, type and so on. I was hoping there would be somethinig equivalent to an .caption argument I could use for each Item in the datacollection but I can't find a way to get the DataLabelsCollection to accept new values.

I have searched MSDN all over, probably 99% of all web sites available not to mention spending all weekend trying to solve this. Any help and ideas are very much appreciated.

/Magnus

**arlu1201** · 08-29-2012, 04:29 AM

Magnus,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.