View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.charting
Sarah Martin Sarah Martin is offline
external usenet poster
 
Posts: 1
Default How do I ignore Graphs zero values.

Sorry for rehashing a really old topic, but I've got that conditional formatting set on the ranges of cells I'm graphing, but the graphs still show the empty categories:

Screenshot of data tables: https://www.dropbox.com/s/ckt2tx7j6zg2i5n/data.JPG?dl=0
Screenshot of graphs: https://www.dropbox.com/s/gctgh55yhp...raphs.JPG?dl=0

Is there any way to make those automatically not show if their value is 0?

-Sarah M