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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,118,766
Messages
5,574,124
Members
412,573
Latest member
Chriszion
Top