Charting Data.

[Shhhh]

Hello all,

Is it possible to create a chart using an entire column, but have the chart
ignor all 0 values?

Thanks,
Shhhh

 

[Mangesh Yadav]

Depends on what type of chart. Also check the use of =NA(), which are not
plotted in scatter charts

Mangesh

 

[Shhhh]

it is a line chart... I'm not sure what the =NA() function is? could you
please elaborate?

Thanks,
Shhhh

 

[Mangesh Yadav]

can you give more details. Whats on the x-axis.

Mangesh

 

[Shhhh]

Mangesh,

the "Y" axis is dates... and the "X" axis is the column with data on it. I
have the chart set up for the whole year and every day... that days "0"
value is replaced with a number.

So basically my chart shows data and then all of a sudden falls all the way
to 0 from tomorrows date on.

Thanks so much for your help,
Shhhh

 

[Mangesh Yadav]

If you remove all the zeros, it should work nicely.

Or, if you can't remove the zeros, then in the adjacent column, put a
formula to get the value of the Y-axis data when it is not zero, else put a
blank, something like this

Column A: dates (X-axis)
Column B: your Y-axis values
Column C: =IF(B1=0,"",B1)

And plot Column C instead of column B on the Y-axis.



Mangesh

 

[Mangesh Yadav]

Another thing, if you already have dates filled up in column A all the way
to the end, then try the same technique with column A, but check data in
column B.

So In column D you would have
=IF(B1=0,"",A1)

Now plot column C as Y-axis and column D as X-axis


Mangesh