View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How can I avoid that zero values in the data set are displayed in.

[Please ask your question in the body of the message, not just in the
subject line.]

Tools/ Options chart gives you various options for empty cells, but if your
cells aren't actually empty but contain zeroes (or "" which counts as zero)
then you may want to replace the zeroes by =NA()
--
David Biddulph

"stef" wrote in message
...