Thread: How do I stop plotted data from going to zero in a line chart?
View Single Post
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default
Use #N/A instead of text.

Jerry

Dozier wrote:

Text in cells are plotted as zeros in Excel 2003 with Windows XP.

Reply With QuoteReply With Quote