Thread: Charts that ignore certain data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mark R[_2_] Mark R[_2_] is offline
external usenet poster
  
Posts: 10
Default Charts that ignore certain data
I have a chart that takes data from a list. Some of the data fields have #NA.

How do I get i to ignore those details so it only plots based upon the true
figures

Abbey 0
First National1
RBS 1
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A

Reply With QuoteReply With Quote