How do I create a line graph which ignores zero values?
Create an IF
function to place an empty value in the cell if it is zero.
IF(function <> 0, function, "")
I know this works in Excel, but not sure about OpenOffice. I am about 95% sure though.