I need to remove the zeroes in a chart
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
"ak_edm" wrote:
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
|