G
Guest
Picture this: a chart for 30 days and 30 values. The values come from a
different table (sheet1!A:G) using the following formula
=IF(VLOOKUP(J11;Sheet1!A:G;2;FALSE)="";"";VLOOKUP(J11;Sheet1!A:G;2;FALSE)).
If the table on sheet1 has no value (""), then the a.m. formula also displays
no value (""). The chart however does show a zero value, which i do not need.
Is there a possibility to not show this zero or no value in a chart?
Thanks for your help!
different table (sheet1!A:G) using the following formula
=IF(VLOOKUP(J11;Sheet1!A:G;2;FALSE)="";"";VLOOKUP(J11;Sheet1!A:G;2;FALSE)).
If the table on sheet1 has no value (""), then the a.m. formula also displays
no value (""). The chart however does show a zero value, which i do not need.
Is there a possibility to not show this zero or no value in a chart?
Thanks for your help!