Zeros in clumn chart

G

Guest

Excel shows a zero length, but that doesn't help I figure (;-).
You could display a data label so it shows "0" - at least you are sure then
it is there
If you want to display a column even when it is zero, you have to trick
Excel with the values (e.g. add +1 to each value which works if you don't
have "-1" as a value. But of course your columns are distorted and the
"relative height" doesnt represent the real relations. Or a stacked column
with a tiny dummy value (say 0.2, the actual values being integers) the dummy
bars with a transparent fill; the "0" shows then as "0.2" with no fill. If
this is not what you seek pls drop another post and I'll see whether I can
find a creative solution (or possibly someone else).
 

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

Top