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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

graphing 1
line graphs 1
Distribution Graph 1
Bar Graph 5
Graphing in EXCEL 1
HELP WITH AN EXPOTENTIAL graph? 1
Chart/Graph colours 1
plotting a single line graph 0

Top