Chart data series refer to defined names

[steven@excelforum]

Hi,

I'm trying to use some defined names to create charts. Though it works at the very begin, some extremely weird things happen when I try to develop further .....

Attached please find the test file, which simplifies my real case but shows the same problem.

Test.xlsx

In the test file, three names are defined as below:

Line1: "=Xvalue*1"
Line2: "=Xvalue*2"
Xvalue: "=ROW(SampleChart!$A$1:$A$25)"

the chart is very sample: "=SERIES(,Test.xlsx!Xvalue,Test.xlsx!Line1,1)"

So far, it works very well. However, I just simply can't add the second line into the chart, for example, "=SERIES(,Test.xlsx!Xvalue,Test.xlsx!Line2,2)"

Further frustrating me is that I can NOT even change "Line1" to "Line2" in the "SERIES" formula!

Why?!

Greatly appreciate any help!

[steven@excelforum]

Is there anybody having a look at the attachment?

Any hints to the problem?

Thanks!

[Andy Pope]

try changing it via the Select Data dialog rather than the formula bar

[steven@excelforum]

Thanks, Andy.

I tried it and failed.

Have you had a chance to look at the attached file? Can you change it? If so, it must be some setting of my Windows or Excel stopping me to change it. Please advise.

[Andy Pope]

Done using xl2007.

Make sure you have the lastest service packs applied.

[steven@excelforum]

Thanks Andy!
I'm using 2007 also but I still can't do it in the file you updated. It seems I have to ask my system admin. to check the SPs.

Thank you again.