1. In Excel 2003, the line chart won't draw the value of #N/A and
leaving it as an empty point. but in Excel 2007, it deal the value of
#N/A as zero. In such condition. I could not drawing some conditional
charts which could associate different scopes of value with different
series and format them differently.

2.the dynamic chart in Excel 2007 seems to be disappointed, I could
not combine the chart with form control. and the relative reference
names( such as data1=OFFSET(Sheet1!$B11,0,0,1,COUNTA(Sheet1!$1:$1 )-1)
could not function too. maybe you could find it by the sample of John
Walkenbach's "define series based on active cell - F9.xls".

3.The mouse's double-clicking function couldn't work too. I used to
format chart element by double-clicking it and set the format options
in its format dialog box. but now I have to rely on ribbon or right-
clicking pop-up menu.

and the other questions is still there too. Could you give me any
suggestion, Thanks in advance.

Yours,fujing