Dynamic Chart Axis Value turn [0]

[fari1]

Hi,
I've a dynamic chart, in which series value are entered as name range. my name range i-e "wa" is

[/CODE]
=OFFSET('All-Ratios'!$AB$2,0,0,(COUNTA('All-Ratios'!$AB$2:$AB$6)-COUNTBLANK('All-Ratios'!$AB$2:$AB$6)),1)
[/CODE]

the chart works fine till the workbook remains opened, but when it is reopened, the axis values turn [0]!wa and the chart becomes statis and also chart gives the msg of "The data range is too complex to be displayed, if a new series will be entered, it will replace all of the series in the series panel".

Any help on it would be greatly appreciated.

Regards

 

[Steve=True]

Try changing your worksheet name from: 'All-Ratios'

to : 'AllRatios'

maybe the dash is the problem?

 

[fari1]

That doesn't resolve the problem, i've tried it
Is it because office 2007?

 

[Steve=True]

i haven't had this problem with 2007

Is it doing this to your data as well or just the axis?

 

[fari1]

it just turns the axis value [0]rangename.

or if its because that i may not have the latest sp updated for excel 2007? its because i've turned off automatic updates.
can you please check your office 2007, if it is currently updated and is having no problems because of it, so that i may be sure that its not because of latest office 2007 update

 

[Kernkraft]

Bump - I'm suddenly having the same issue as well, I have excel 2007 - wondering if its some office update that wiped out all of my dynamic charts.

 

[fari1]

u've to install latest updates of excel 2007, its latest patches have been issued by microsoft. i installed them and run them and then that problem was resolved.