Hi,

How can I show zero values in a column chart?

--
Mifty

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).

"Mifty" wrote:

Hi,

How can I show zero values in a column chart?

--
Mifty

Thank you, any help will be appreciated
--
Mifty


"HEK" wrote:

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).

"Mifty" wrote:

Hi,

How can I show zero values in a column chart?

--
Mifty