Graph Range


D

Duplatt

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
 
Ad

Advertisements

B

Bernard Liengme

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
 
Ad

Advertisements

D

Duplatt

Thank you Bernard. Works fine now.

Bernard Liengme said:
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
 

Top