Does excel chart have feature to show series data only numbers.
In other words my chart have 10 rows predefined formula references and i want
to plot graph based only only numerical values available in rows and if any row having text value, graph should be stopped on the last numeric point.
currently chart prepared by me automatically pick 0 (zero) where ever any text value appear in the said seris.
pls treat this urgent