I am attempting to use FusionCharts v3 to output some data which is returned from the database into a Recordset called RS.

The Data is held the recordset as follows...

Month                 Year                   Counter

2                        2006                  10

3                        2006                  56

6                        2006                  32

1                        2007                  34

What I am trying to do is to get the chart to complete the missing months with a value of 0 to show that there was nothing for those months.

At the moment I am using a while loop to write out a strXML which is than passed to the chart, it works although I can't seem to find a way of filling in these missing dates.

Can you please help?

Thanks,

Stewart

I am afraid, FusionCharts does not detect month values to auto-fill the gaps. In the while loop while fetching the values from database, you need to code yourself to fillup the missing gaps with 0 value.

Regards,

Sudipto Choudhury
FusionCharts Team