Hi Li Meiying NAN means 'Not a Number', which is a normal requirement as a value in these cells. Instead of deleting a value, if you replace it with 0 then scrolling works. A blank value cannot be calculated but 0 can. Also, 'Test' is not accepted for the same reason that it is not a number. Regards Bill
2009/5/31 limeiying <[email protected]> > Hi all, > > In Writer, insert-Object-chart, this moment the chart can be edited, Right > click on the chart - select "Chart data table" - delete any Y-values in any > column, then scroll the middle key of the mouse, then "1.#NAN" shows in the > data table. > > Note, > If don't delete the data in the table cell and scroll the middle key of the > mouse, values alter. > But if enter characters like "test" or enter nothing in the cell, then > scroll the middle key of the mouse, “1.#NAN” shows. > > Everyone, would you like giving me a hint? > TIA > > Regards > Li Meiying > ------------------ > Beijing Redflag 2000 Software CO.,LTD > MSN:[email protected] <msn%[email protected]> > Email:[email protected] <email%[email protected]> > Tel:51570010-6140 > Fax:51570333 > Code:100176 > Date:2009-05-31 >
