I need to remove the zeroes in a chart

[ak_edm]

Hi,

My spreadsheet along a row looks like this (the spaces are cell-to-cell).

15 17 18 6 19 0 0 4 18 6 15 0 0 6 18 0 19 0 20 23 etc... for a long time.

I'd like the line graph to reflect only the non-zero numbers.

The problem I'm running into is I cannot CTRL-SELECT only the parts I need
cause apparently there's a character-length limit of the selected information
in the Source Data for the chart. In other words I can CTRL-SELECT "15 17 18
6 19" then CTRL-SELECT "4 18 6 15" and so on but eventually I cannot
CTRL-SELECT any more. It's a messy solution anyway.

Another solution would be to automate copying only the non-zero numbers into
another row, such as 15 17 18 6 19 4 18 6 15 6 18 19 20 23 etc... But I'm not
familiar with macros (VBA??) and cannot figure out a function to accomplish
this.

Another solution would be that there's somwhere in chart options to only
include non-zero data.

Any ideas?

- Eric

 

[Mike H]

Hi,

Zero will plot on a chart. If your zeroes are as a result of formula and
want to ignore them make the formula return NA() instead of zero and the
chart will interpolate between the adjacent values and ignore NA()

Mike