urbanson

Hpefully it is a simple case and you can help me I have three recordsets: first has 12 values from January to December second: recordset has 5 values from August to December third has values only for May and July. All of them are in the same year. I do a Multi Series Chart to have three diferent lines but at the chart these lines start from the same point which is January!!!!! So the first records set has a line from January to December which is correct. Second line start from Janury to May which is totaly wrong and third line start from January to March which also wrong! How does it come?!! How can I make this working? HELP Is there any special Category option? What Should I do to have the same data on the chart as in database? Thanks in advance! (PHP, Mysql)

Hi there! Thanks for help. However the problem is that in case you showed me it has to be reported value "0" each month for each product which is really time consuming. I can not afford it. Is there any other way? and what about line chart instead of columns? Does data have to be in XML?

Hopefully it is a simple case and you can help me I have three recordsets: first has 12 values from January to December second: recordset has 5 values from August to December third has values only for May and July. All of them are in the same year. I do a Multi Series Chart to have three diferent lines but at the chart these lines start from the same point which is January!!!!! So the first records set has a line from January to December which is correct. Second line start from Janury to May which is totaly wrong and third line start from January to March which also wrong! How does it come?!! How can I make this working? HELP Is there any special Category option? What Should I do to have the same data on the chart as in database? Thanks in advance! (PHP, Mysql) Urbanson