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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,113,790
Messages
5,544,296
Members
410,601
Latest member
Silver2
Top