Hi,

the best way to handle this is by laying your data out vertically. The
create your chart and apply a filter to the Date column of the data. Charts
only plot visible cells by default.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Marius" wrote:

Hello,

I have to create a chart to follow-up some data among the entire year.
Obviously the values for July-Dec (for eg) are not available for the moment.
Therefore the value for July-Dec are 0.

A line chart will show all the values, the ones 0 from January until June,
and 0 for the rest of them. I need my chart to stop in June. I tried to put
<blank or N/A for the months to come but the chart still shows 0.

Do you have any suggestion?