I am looking for some guidance on how to populate a StackedBar chart with Sparse data. Take for example the 3 categories of Animals : Monkeys, Dogs, Cats. My Data set then includes counts of those animals for a given period of time
2010 - Dogs = 7, Cats = 5, Monkeys = 0
2009 - Dogs = 4, Cats = 0, Monkeys = 3
2008 - Dogs = 0, Cats = 0, Monkeys = 22
I don't want the chart to render the zeroes for the animals when they are missing. I just want to present the data for animals that are present. I am building my data now from a List of double[] which does not appear to do the trick. I tried passing in NaN for the blank postions or using double? and NULL but that did not work either.
Please provide some guidance here.
Thanks
2010 - Dogs = 7, Cats = 5, Monkeys = 0
2009 - Dogs = 4, Cats = 0, Monkeys = 3
2008 - Dogs = 0, Cats = 0, Monkeys = 22
I don't want the chart to render the zeroes for the animals when they are missing. I just want to present the data for animals that are present. I am building my data now from a List of double[] which does not appear to do the trick. I tried passing in NaN for the blank postions or using double? and NULL but that did not work either.
Please provide some guidance here.
Thanks