Thursday, August 30, 2012

How to Stop Excel from Graphing Missing as Zero?

A forum post suggested using =NA() (i.e., #N/A) in your empty cell instead, and that works for me.

Reference: Excel Graphs - stop empty cells showing as zero [PC World Australia]