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?
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?