Do not show lack of data as a zero on graph lines, leave blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used to know this but got new software. If I leave a blank in a line of
data and at the end of the data, the graph line drops to zero. I just want
it to igore blank spaces.
 
1) replace blank by =NA(); displays as #N/A
OR
2) click on chart; use Tools|Options; open Chart tab; set how to Plot Empty
cells
best wishes
 
Back
Top