Chart option to suppress zero values??

Hello,

my table consists of production data for different shifts. As the
shifts some days are off duty, they do not have production, so for
that day, their production is zero.

What I want is a graph, where the line is connected from the last day
when there was a production to the first day of production after that,
without the graph going down to zero in between.
Is that somehow possible or what can I do?

If they actually show a value of zero, you would be hard pressed to ignore
them. If you leave them blank, with the chart select, go to tools=>Options
and select the Chart tab. You have 3 options: not plotted (leave gaps),
zero, interpolate. If you wanted to filter these zero rows so they are
hidden, then you could use the plot visible data only option in that dialog.

--
Regards,
Tom Ogilvy


"Norbert Jaeger" <n.jaeger@gmx.net> wrote in message
news:6ordf1dpsid9tmmbt0hvng6u4vcqvd9qrh@4ax.com...
> Hello,
>
> my table consists of production data for different shifts. As the
> shifts some days are off duty, they do not have production, so for
> that day, their production is zero.
>
> What I want is a graph, where the line is connected from the last day
> when there was a production to the first day of production after that,
> without the graph going down to zero in between.
> Is that somehow possible or what can I do?

If, as I think you are asking, you want the line to ignore zero values and
continue to the next non zero, replace zero values in cells with #N/A

Or, to break the line over zero values ensure these cells are empty.

Regards,
Peter T

"Norbert Jaeger" <n.jaeger@gmx.net> wrote in message
news:6ordf1dpsid9tmmbt0hvng6u4vcqvd9qrh@4ax.com...
> Hello,
>
> my table consists of production data for different shifts. As the
> shifts some days are off duty, they do not have production, so for
> that day, their production is zero.
>
> What I want is a graph, where the line is connected from the last day
> when there was a production to the first day of production after that,
> without the graph going down to zero in between.
> Is that somehow possible or what can I do?