Not plot zero values in pivot charts

[GenV]

My data does not have any blank or zero values. My pivot table created from the data has produced zero values in a few columns (which is correct), hence the pivot chart is leaving gaps for them. How can I stop these gaps or hide them? Please see the uploaded file.

 

[NARAYANK991]

Hi ,

It seems to me that you will get a better looking chart if you change your chart type.

See the file.

Narayan

 

[GenV]

Hi ,

It seems to me that you will get a better looking chart if you change your chart type.

See the file.

Narayan

It does look better, but I definitely need it in the other chart type not the stacked chart type.

Any ideas?