Adding special symbols to chart data labels

Aspose.Cells Product Family
1

I need to add special symbols (e.g., ascii 135 - the double dagger) but I haven't been able to figure out how to do it. Simply setting the label results in the Excel chart displaying a little box with a question mark in it. It's obviously not recognizing my input as a displayable character. Any help would be appreciated.

Sample code:

chart.NSeries[seriesCtr].Points[pointsCtr].DataLabels.Text = Convert.ToChar(135).ToString();

Thanks

2

Hi,

I have logged your issue into our issue tracking system with an id: CELLSNET-19583. We will look into it and get back to you soon.
Thank you.

3

Hi Rick,

You can directly use Unicode of the symbol as followings:

chart.NSeries[0].Points[0].DataLabels.Text = Convert.ToChar(0x2021).ToString();

Thanks,

4

Hi,

After further investigation, we found it is not an issue. Please directly use Unicode symbols, See the following code segment:
chart.NSeries[0].Points[0].DataLabels.Text = Convert.ToChar(0x2021).ToString();

Thank you.

5

Thanks Amjad. As it turns out, I stumbled across the unicode solution myself last night and determined that the following code works:

chart.NSeries[0].Points[0].DataLabels.Text = "\u2021";

This will produce a double dagger symbol. Anyone who needs the unicode special symbol codes should check out the following url:

http://www.unicode.org/charts/charindex.html

Thanks again for your help.