| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Graph Range
My graph range value is ec6:ec46
sometimes the last 4 or 5 cells at the end of the range are 0 that makes the curve go straight down Is there a way to specify a range with only numbers greater then 0 within the range. The 0 cells will always be at the end of the range Thank You Duane |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Graph Range
a) replace the 0 by =NA() (displays as #N/A) which the chart engine ignores
or b) replace 0 by blank (ie delete the cells);click on chart and use Tools | Options; open Chart tab and specify how Excel is to treat empty (missing) data or c) Google with EXCEL CHART DYNAMIC and make a dynamic chart best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Duplatt" wrote in message ... My graph range value is ec6:ec46 sometimes the last 4 or 5 cells at the end of the range are 0 that makes the curve go straight down Is there a way to specify a range with only numbers greater then 0 within the range. The 0 cells will always be at the end of the range Thank You Duane |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Graph Range
Thank you Bernard. Works fine now.
"Bernard Liengme" wrote: a) replace the 0 by =NA() (displays as #N/A) which the chart engine ignores or b) replace 0 by blank (ie delete the cells);click on chart and use Tools | Options; open Chart tab and specify how Excel is to treat empty (missing) data or c) Google with EXCEL CHART DYNAMIC and make a dynamic chart best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Duplatt" wrote in message ... My graph range value is ec6:ec46 sometimes the last 4 or 5 cells at the end of the range are 0 that makes the curve go straight down Is there a way to specify a range with only numbers greater then 0 within the range. The 0 cells will always be at the end of the range Thank You Duane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create range bar graph | Charts and Charting in Excel | |||
| User-defined range for graph | Excel Discussion (Misc queries) | |||
| Dynamic Range Names For a Graph | Charts and Charting in Excel | |||
| Automatically changing the range in a graph | Charts and Charting in Excel | |||
| How can I vary graph color by range value | Charts and Charting in Excel | |||
Linear Mode
