Thread: How to chart a series and ignore values of 0

I want to chart productivity of employees. The shart is rather simple, an efficiency rating on the Y axis and time one the X - generally two week intervals, but just as easily and maybe more simply for this lets just say days of the month. I don't want to have to go in and adjust the series every day for the additional day, but then if I take the entire month of days into the series, all the ones beyond the date of last data entry are 0 and cause that crash at the end of the table, and highly distort any trend line superimposed.

Is there a way to tell it instead of $A$1:$A$31 to go from $A$1 to the end of the entries >0 (I am using those cell entries as a matter of example, again trying to simplify things!)?

Pursuing another forum users query, I was lead to what appears to be my answers at:

http://office.microsoft.com/en-us/ex...098011033.aspx
and
http://www.meadinkent.co.uk/xlgraphoffset.htm