Charts problem

[cata2200]

Hello

I have a table where to collect working hours per day, during one month (many entries for one day). Few columns after, I am using a another table to summarize the these data per day.

I would like to show them on the chart (Line template) but I would like the chart to stop displaying the line, if number of hours in one particular day is zero.

Any help?

Thanks in advance,
Catalin

 

[Robert Mika]

Look at this:
http://www.mrexcel.com/forum/showthread.php?p=2941123#post2941123

 

[cata2200]

Many thanks, but... not working.

Apparently, while "dismantling" the formula, the error is under the LEN(... area.
Any help?

 

[Robert Mika]

What kind of error?
Could you post yur formula/screenshot?

 

[cata2200]

I have uploaded to my Picasa.

https://picasaweb.google.com/100583380472031255082/December82011#5683692357929428242

What I need is to avoid displaying the "0" values in chart.
I 've done the recommended steps to creat "Months" name.

Thanks a lot.
Catalin

 

[cata2200]

OK.
Temporary ... solved. I've replaced the 0 (zero) values with "" (null) and the array is defined up to the first "".
Chart will not display the rest of the days (in the month), but I could manage to modify the X-axis from the menu, up to end of the month.

Many thanks for help.

Regards
Catalin