Forum Discussion
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;-...
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
Sergei,
That is a very interesting way to solve this problem! Meaning that I would have NEVER gotten to that answer, lol. I would have danced around a solution for a very long time. I appreciate your skills and I hope that I can reach out to you in the future to steal more of your knowledge!
Yukontornado69 , thank you. But that's not the universal solution, just workaround for this concrete case. For another data that could be something else.