A
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
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