View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
 
Posts: 140
Default Dynamic Range for Area Chart with a line graph inside it too

Hi Bernard - This now returns #NAME? and the graphs still plots them as zero?
Am i doing something else wrong.

Thanks
Matt



Bernard Liengme wrote:
Thanks for feedback
My first point was to type =NA() (not =N/A)
The NA() function returns (ie displays) the value #N/A
best wishes
Hmmmmm

[quoted text clipped - 22 lines]
Regards
Matt


--
Matt Lynn

Message posted via http://www.officekb.com