Show Series Name on only one data point (chPoint)

S

sxzy

Set label = series.DataLabelsCollection.Add
label.HasSeriesName = true

This will show series name (e.g. "Series1") for every data point in the
whole series. (can get very ugly!!)

To make things clean I would like to show series name only on ONE
particular data point - let's say 5th data point. In Excel this is
possible, how about OWC chart? I've spent hours.

I guess what I'm trying to do is this:

Set label = series.Points(4).DataLabelsCollection.Add
lab.HasSeriesName = true

But that doesn't work. What to do?

Thanks,

Sergey
 
A

Alvin Bruney - ASP.NET MVP

that functionality is not supported

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
 
S

sxzy

Thank you Alvin. Kind of disappointing, since adding labels to the
whole series doesn't seem practical at all. They get mushed up and hard
to read.

Question: Why is there functionality to have multiple DataLabels for
one series?
Meaning I can do: series.DataLabelsCollection.Add. Why would anyone
have more then 1 set of data labels for single series?
 
A

Alvin Bruney - ASP.NET MVP

The flexibility is there so that you can add a label to every point if you
so desired. What you wanted was to add a series name for one point. One
workaround is to turn off all labels and use a datalabel to substitute -
pick a point and draw that datalabel as appropriate. It will accomplish what
you want, just not with the series object.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
 

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