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

Thread is closed for posting
2 posts, 0 answers
  1. Ryan
    Ryan avatar
    8 posts
    Member since:
    Oct 2012

    Posted 06 Feb 2013 Link to this post

    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?
  2. Petar Kirov
    Petar Kirov avatar
    425 posts

    Posted 11 Feb 2013 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Back to Top