Chart displaying #N/A instead of nothing

[AusSteelMan]

Hi everyone,

I have a chart that is now displaying the NAs. It didn't used to in XL2000, but is in 2007.

I have searched the net and can't find a solution. Can anyone here help please?


I think it may also appear in 2003 at home: but this is a feint recollection since I don't usually use this workbook at home.

Thanks for any help you can provide.

Darren

 

[GlennUK]

The NAs are ignored in 2007 when I try it. Have you applied all service packs, and applied the latest Hotfix:

http://support.microsoft.com/kb/2427447

 

[AusSteelMan]

Most of the charts that have NA work OK, but I have 1 workbook where a couple of series on different charts don't work.

I'll try deleting the series and adding it again.

Also, plrobably needed to be more specific that this book was developed in 2000, occasionally updated/viewed in 2003 and as of last week am using 2007 in place of 2000.

Thanks for your feedback anyway Glenn.

Darren

 

[AusSteelMan]

So I deleted the series and added it back in and all good. "Oh well" I thought. Then 5 mins later added the data labels and BAM - the NAs were back. Yes, I'm a little embarrassed to have not picked that up in the first place.

So it was OK in the first place, just the labels were showing. I really only want the non NA labels to display. I will try and make this work. If have no luck, I suppose i will be back!!

Thanks to all those that took interest.
Darren