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?