Hi there,
I am using the following formula to pull data in "=VLOOKUP($E$5,'TY Sales'!$A$2:$BC$23,G$13+3,FALSE)" to use in a chart however the blank cells are returning a value of zero.
Is there a way that I can make the cells with Zero blank so that it excludes it from the chart?


Thanks

Justin.