Thread: Dynamic Ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Patrick Patrick is offline
external usenet poster
 
Posts: 160
Default Dynamic Ranges

My x category are months. I have 13 data series. I usually create a chart
monthly of the previous 3 months data. Would I have to name each data series
separately to use a dynamic chart? I also often have individual values that
are zero. Would using a dynamic chart show the zero value as blank? I have
tried using the na(), but NA# appears on my chart and I end up having to
delete the labels individually.