Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
405
How to have Null values in a line chart
posted

Hello... I'd like to create a line chart similar to the one below... except on the lower line, it shouldn't drop to the x-axis if the value doesn't exist (currently being set to dbnull)... I just want it to plot the points it has.  Is there any way to do this?

Currently, I'm building a datatable with the columns being (Name, 4/1/2010, 4/2/2010, ...) and the rows being each line... so the datatable for the chart below consists of two rows and 13 columns (1st being Name and then 12 dates). 

Any ideas?  I want to be able to chart date-based collections where each name may not have the exact same date list. 

Thanks

Rocky (v8.3)

Parents Reply Children
No Data