I knew it would be an easy one. I actually never went to Tools, Options
...... for charts, always used right click on the chart or graph line only.
Thanks for helping. It works now.

Cheers,
Norbert


Hi,

So it sounds like your data is set up correctly.

Select the chart and the use Tools Options Chart Plot empty cells
as Not Plotted.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Norbert" wrote in message
...
Hi Andy,
I think that is exactely what I've actually done.
my source data come from:
='shift plan'!$W$278:$W$308
the content of these cells are the efficiencies: e.g. 78%
the cells for the weekends are completely empty.

the category (X) axix labels come from:
='shift plan'!$A$278:$A$308
A278 represents the 01-10-2008
A308 represents the 31-10-2008
but the cell entries are actually formulas like: A277+1
in A2 is the 01-01-2008
every cell further down, just adds 1 day.

Hope you can help.
Norbert


Andy Pope wrote:
Hi,

To have a line that breaks you will need to have dates in your series
for the weekends and no data for the equivalent points.
If you just made the axis Time series the line would be interpolated
between Friday and Monday data points.

Cheers
Andy