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

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.

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Steve" <Steve@discussions.microsoft.com> wrote in message
news:565DB5EA-E9C8-402D-9134-7F204F688880@microsoft.com...
> 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.

Thank you very much; it worked perfectly for what I was trying to do!

"Bernard Liengme" wrote:

> 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
>
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Steve" <Steve@discussions.microsoft.com> wrote in message
> news:565DB5EA-E9C8-402D-9134-7F204F688880@microsoft.com...
> > 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.
>
>
>