How can i display zero values in a chart

[geogou1973]

Hello.

I have a problem in a chart that not appears the zero values.

I have a table that with items and qty. Some qty are zero.

When i create a table all the items appears in it but when i create a chart suppress all the items that have qty zero.

Can someone tell me what i can do in order to display all the items ?

Thank you in advance.

[sunny_talwar]

Try this in your expression:

If( yourExpression = 0, 0.00000001, yourExpression)

Let me know if it works.

Best,

S

[rubenmarin · Accepted solution]

Hi gou, in presentation tab, try to uncheck "supress zero values"

[#4]

Hi

in chart properties / presentation tab / untick Suppress Zero Values

best regards

[Anonymous]

Hi,

Go To Chart Properties - Presentation tab - Uncheck Suppress Zero-values checkbox

Regards

Neetha

[agomes1971]

Hi,

at the Chart Properties in the Expression Axes tab take a closer look if Forced 0 is checked...

Regards

André Gomes