Forum Discussion

Yukontornado69's avatar
Yukontornado69
Copper Contributor
Apr 12, 2019
Solved

Office 365 Excel - Bar graph and zero values

I have data being pulled from other cells via formulas.... ex. =IF(ISBLANK(S103)," ",(S103))     This populates a cell in a chart that is used in a graph.  It is currently formatted as "Custom: 0.0;-...
Charting
excel
Formulas and Functions
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 17, 2019

    Yukontornado69 ,

     

    Yes, chart converts empty string ("") to zero. As workaround, in G156:R156 you may use formula like

    =IF(ISBLANK(I7),-1E-20,I7)

    instead of 

    =IF(ISBLANK(I7)," ",I7)

    and apply to these cells custom format

    [<0]"";[>=0]0.0

    I assume all your numbers are zero or positive ones.

    That returns such cells formating

    and the same for the chart

Resources