excel graph falling to zeroooo


  1. Posts : 36
    win 10
       #1

    excel graph falling to zeroooo


    hello, in trying to prevent my graph from falling to zero when the if in a cell that's plotted doesn't show any value because conditions aren't met

    excel graph falling to zeroooo-clipboard02.jpg

    =IF(ISBLANK(I79),"",I79+M79+N79+P79+O79+(Q79*T79))

    any ideal how i could just stop the plotting wheres theres nothing in the cell?

    excel graph falling to zeroooo-untitled.jpg

    thanks :)
      My Computer

  2.   My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 03:25.
Find Us




Windows 10 Forums