TM1Web chart error

[istvan kreko]

Hi everybody,

I've created a very attractive excel chart and wanted to publish on TM1Web, the data table works fine but the chart doesn't appear on the web at all (tm1: 9.4.1 SP2, excel: 2003 SP3 (Hungarian).
Instead I am getting the following error message:

An error occurred while calculating chart series information

I've checked the tm1web.log as well:

2010-06-08 13:54:54,087 [1] ERROR Applix.TM1.Web.WebControls.Websheet.TM1WebFormula - An error occurred while parsing the formula: "SERIES(Munka1!S5O4;Munka1!S4O5:S4O9;Munka1!S5O5:S5O9;1)"
System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef.ParseCellRefString(String cellref, ReferenceStyle refStyle)
at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgRef..ctor(ITM1WebObject parent, String sheetname, String cellref, ReferenceStyle refStyle)
at Applix.TM1.Web.WebControls.Websheet.FormulaParser.PtgArea..ctor(ITM1WebObject parent, String sheetname, String firstcellref, String lastcellref, ReferenceStyle refStyle)
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.ParseIdentifier()
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.ParseFactor()
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.ParseTerm()
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.ParseExpression()
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.ParseList()
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.ParseFunction(String name)
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.ParseIdentifier()
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.ParseFactor()
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.ParseTerm()
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.ParseExpression()
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.ParseList()
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula.ParseFormula()
at Applix.TM1.Web.WebControls.Websheet.TM1WebFormula..ctor(ITM1WebObject parent, String formula, ReferenceStyle style)


Any ideas how to solve this?
Thanks
Istvan