Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart to display zeroes values | Charts and Charting in Excel | |||
how to remove dotted line with words chart area from around chart | Charts and Charting in Excel | |||
Chart data with zeroes | Charts and Charting in Excel | |||
how do i remove zeroes values from exel sheet | New Users to Excel | |||
Pivot chart: get rid of zeroes? | Charts and Charting in Excel |