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

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 'ToolsOptionsChart' but the 'Plot empty cells as Not plotted
is greyed out'.

Can anyone help?!

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

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()).
--
David Biddulph

"Kirsty W" <Kirsty wrote in message
...
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 'ToolsOptionsChart' but the 'Plot empty cells as Not plotted
is greyed out'.

Can anyone help?!