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

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?!
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank cells in graph 8
Surpressing plot of blank cells 3
exclude blank cells in a line graph 2
I don't want to graph "null" values? 1
Graphing Question: Blank Lines Problem ? 2
Suppres Zero or empty Cell value in a line graph 1
Hiding Data Points in a chart 1
Excel Graph Problem - Need Help 2

Top