Blanks graphed as zeros

Lisa928

Board Regular
Joined
Jun 13, 2002
Messages
173
I have a building YTD graph where the data is pulled from another source.

I am using a formula where it will pull the data, but if that month it is not available yet (or =0) then "", or a blank. The problem is the graph is graphing the blank as a 0. Because of this the line graphs looks like it plummets. Instead I want the line to just end.

Can I do this by formatting my data differently instead of VB?
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,119,240
Messages
5,576,903
Members
412,753
Latest member
Coach_Olson
Top