How do I leave out blank cells in a line graph?

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

Guest

I have a line-graph linked to a table of data. Some cells in the data table
are blank (these cells have an apostrophe in), and at the moment the line
graph displays these cells as zeros. But I'd like these blank cells to be
omitted in the graph, and not displayed as 0.

I've tried 'Tools>Options>Chart>' but the 'Plot empty cells as Not plotted
is greyed out'.

Can anyone help?!
 
Either blank, or with an apostrophe, won't be treated as empty. If the
cells aren't totally empty, try replacing the contents by N/A#.
Perhaps IF(ISNUMBER(A1),A1,NA()).
 
Back
Top