combo chart not plotting 0 ??

[#1]

Hi,

I'm building a combo chart like below.

The line value for May is 0, and i have the option "suppress zero value" checked.

Is there a way, i can still have a dot at 0 for May's line ?

Otherwise, it's very misleading, isnt it?

or is this already a known bug ?

[jonathandienst]

Hi

If zeroes are suppressed, what value should be shown for the line in May? If you want to force a zero to show for May and not elsewhere, you may have to fake it by using a very small non-zero value.

What basis do you have for showing the zero for May, and not for Jan and Feb?

Regards

Jonathan

[#3]

Hi Jonathan,

That's what i'm doing now, to put an IF statement around the formula and plot 0.0001 when the formula return 0.

The formula is something like (A1 - B1) / A1.

but only when both A1 and B1 is not 0, then plot the line with its figures..