Bar Chart

[#1]

Hi,

  i have created a bar chart with Quarter as X axis and Amount as Y axis. I am getting the values correctly. But suppose there is no value for Quarter Q2 then the X axis is not showing the label Q2 and there is no value at Y Axis.

I want to show the X Axis Q2 with Y Axis vlaue as 0. Is it possible to do it ?

[SunilChauhan]

chart properties-> presentation->supress zero values->uncheck and ok

[kji · Accepted solution]

Check that "Suppress Zero-Values" is unchecked (Presentation tab) and you might also want to have "Show All Values" enabled for Quarters (Dimension tab).

[#4]

Thanks Sunil and Johan,

Sorry i have edited the rsponse it showing as expected after chaning the properties inthe presentation tab.But it is showing as Q1,Q2,Q3,Q4,-  It is showing '-' as one of dimesion value. I am not sure where it is coming from. How to eliminate this

[#5]

In the chart Properties, go to Dimensions and check Supress when value is Null.

[SunilChauhan]

you need to follow this

chart properties-> presentation->supress zero values->uncheck and ok

see my post above

and not check show all value .then it will not show you  '-'

and also required to supress null value.