Thread: Dynamic Ranges
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default Dynamic Ranges

Hi,

For more information, refer to the following URL:
http://peltiertech.com/Excel/charts or enter Peltier Technical Services, Inc
in the Google Search.

Challa Prabhu

"patrick" wrote:

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.