Is it possible to add null value to a chart series and have it show empty in the datatable?

[Ryan]

I have a chart with a datatable and I need to be able to have an empty value for one of the values.  When I add the value as Nothing, the value is set to the next value in the series (6,100 in the attached image) and will show up as 6,100 in the datatable.  I was able to make the point mark not show on the chart by setting the empty property to true, but I need to be able to set the value in the datatable to either a blank field or N/A.  Is this possible?

[Petar Kirov]

Hi Ryan,

The result you get is because the default empty value mode of the ChartSeries is Approximate. You can change that to Zero:

chartSeries.Appearance.EmptyValue.Mode = EmtyValuesMode.Zero;

However I'm afraid that you can't customize further the empty values behavior of the DataTable.
That is why I would recommend using a RadGrid instead - it offers a vast amount of customization and client side functionality.
 
Kind regards,
Petar Kirov
the Telerik team