Zero values

B

Bernard V Liengme

You cannot get a chart to treat 0 as anything but 0. You can have a chart
ignore missing data. In the missing cell enter =NA(); this could be part of
a formula =IF(whatever, somevalue, NA())
You can also, with the chart selected, use Tool|Option|Chart to tell Excel
how to treat missing values.
Hope this helps
Bernard
 

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

Hide the decimal "." point in chart 0
Displaying zero values as gap in a chart 1
zero values 1
Do not display Value label if value = zero 1
2003 Excel Chart with zero data 5
Suppres Zero or empty Cell value in a line graph 1
linear charting with zeros 7
Non-number value in Charts 5

Top