View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Gingerly Gingerly is offline
external usenet poster
 
Posts: 12
Default Skipping Text Entries

One of my charts contains "N/A" entries. Right now they are showing as zeros
on the chart. I went to OPTIONS/CHART and the chose the LEAVE GAPS choice but
they are still showing as zeros. Is there any way to skip that week if the
entry is non-numeric? Thanks.