I need to remove the zeroes in a chart
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 |
I need to remove the zeroes in a chart
Perhaps the options at Tools Options Chart for the plotting of zero value
might help. Vaya con Dios, Chuck, CABGx3 "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 |
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 |
All times are GMT +1. The time now is 07:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com