Axis Labels as Int

[Kellen]

I've got an interesting problem where I cannot get my Xaxis labels to display as a string! The values are usually numeric but are also occasionally alpha/numeric. I've searched and searched and cannot figure out why it would be behaving this way. I've got a bar graph and, for example, if the label data is "X1500" for a given column it is displaying as "0". It looks to me like reporting is trying to parse it as an int...? Also, if the value is supposed to be "00018" the graph is displaying that value as simply "18" (dropping the leading zeros)...
 
Also, I'm using the exact same field as label text in another part of my report and it is displaying properly there.

HELP! Thanks.

[Ves]

Hello Kellen,

I am afraid, there is a bug in the chart item for scenarios like this. The workaround here would be to populate the ChartSeries with their ChartSeriesItems manually and do the same for the XAxis. Here is an example for data coming from a DataTable:

RadChart1.PlotArea.XAxis.AutoScale = false;
RadChart1.PlotArea.XAxis.Items.Clear();

for (int i = 0; i < tbl.Rows.Count; i++)
{
     ChartSeriesItem item = new ChartSeriesItem((int)tbl.Rows[i]["Value"]);
     RadChart1.Series[0].Items.Add(item);
     ChartAxisItem axisItem = new ChartAxisItem(tbl.Rows[i]["Name"].ToString());
     RadChart1.PlotArea.XAxis.Items.Add(axisItem);
 }

Kind regards,
Ves
the Telerik team

[Kellen]

Thanks. Another work around I found was to add a character like an * or | before the label data... of course then I have a funny out-of-place character before my labels... but that's acceptable for what I'm doing. Thanks again.

[Steve]

Hi Kellen,

Improving on your workaround is adding a Zero Width Space character instead of a bogus character before the label data.

Kind regards,
Steve
the Telerik team