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 ?
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?
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..
Retrieving data ...