In Trend chart (Bar chart) don't have the month value it will display the 0 as bar

[Ramu_i]

Hi All,

I have bar chart and Combo chart, Here shows the last 12 months data .

some months don't have the data , If don't have the data it will display the 0 value , if data is there display the bar.

Please help ,thanks advance.

Regards,

Ram 

[Aditya_Chitale]

something like this ?

Try adding data value labels and tick include zero values under add ons->Data handling tab if its unchecked.

[Ramu_i]

Hi Aditys Chitale,

I tried this one but it's not working fine. 

here showing only values shows bar only. not showing zero values.

Regards,

Ram

[Aditya_Chitale]

@Ramu_i , can you share rough representation of how you want to show the output ? as for data values, they are show on top of the bars. 0 for Apr, Feb and May in my snapshot

Regards,

Aditya

[Ramu_i]

Hi Aditya,

Thanks for given the information.

Regards,

Ram