1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.CH

  • How do I ignore Graphs zero values.

    From Sarah Martin@21:1/5 to All on Fri Aug 14 11:18:45 2020
    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/gctgh55yhpdnklu/graphs.JPG?dl=0

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

    -Sarah M

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)