Excel Chart

Hi

 

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

By: samta

Leave a Reply

Your email address will not be published. Required fields are marked *