E
Ed Needshelp
Oh Gods of Excel please help me.
I want to use a line graph to chart the production of a given machine
but on the days it doesn't run, I don't want the zero productio
included as one of the data points.
I pull the summary data for the chart by using an "IF" statement tha
returns either the production for that day or a "" (blank) when it'
zero. I was hoping that it would treat the blank like an empty cell
but it treats it like a zero.
Is there anyway to get around this
I want to use a line graph to chart the production of a given machine
but on the days it doesn't run, I don't want the zero productio
included as one of the data points.
I pull the summary data for the chart by using an "IF" statement tha
returns either the production for that day or a "" (blank) when it'
zero. I was hoping that it would treat the blank like an empty cell
but it treats it like a zero.
Is there anyway to get around this