For my benefit and the OP's, does someone know how to change the "how should excel treat blanks in charts" options in 2007/2010. I know how to do it 2002/2003, but not in the later versions: http://www.excelforum.com/excel-char...ml#post3552017