easy one!

[Norbert]

my chart displays the efficiency of machines per day in one month.
as we do not work on Saturdays and Sundays I do not have any values for
those days, but I still want to keep the days as we might work Sat. or
Sundays.

How can I have the line of my graph interrupted instead of connected
between Friday's and Monday's values?

Norbert

 

[Andy Pope]

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

 

[Norbert]

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]

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

 

[Norbert]

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
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