Is there a way to not show a dash as a zero in Excel chart?

G

Guest

I'm setting up an spreadsheet to pull data and automatically graph a defined
array of cells in a chart. When I have a dash (-) showing up in a cell, it is
graphed as a zero. Is there any logic that I can implement so that a dash
doesn't show up on the chart. I tried If/then statements where the "-" would
be replaced by " " but that still graphed a zero.
 
B

Bernard Liengme

You were nearly there: use =IF(A1="-",NA(),A1) to get #N/A in the cell next
to the dash; Excel will ignore these when plotting
 

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

I don't want to graph "null" values? 1
Hiding zero values on a chart in Excel 2007 2
Best way to show this on a graph? 3
surface chart 1
Chart won't show zero percent 1
Hide Cells with Zero Value in Excel 2007 while using line chart ty 4
Displaying zero values as gap in a chart 1
Excel 2007 Chart with Zero Values 5

Top