How can I hide 0 value data labels in stacked bar Chart?

kiyami

I would like to hide data labels on a chart that have 0 as a value.

Data table :

Market	Product 1	Product 2
Market A	0	3
Market B	5	0

With this data source, stacked bar chart is display:

But I would like this chart:

Notice the 0 labels are hidden and are related to different products and markets.

How I can do this?

Thanks!

nm.Mani

Hi kiyami

similar to excel ( How can I hide 0-value data labels in an Excel Chart? - Super User) just change the column properties from number to custome (#). it worked for me.

thanks

MM

nm.Mani

Hi there,

if this worked for you, why not mark it as answered? otherwise let us know