Hiding Zeros in Stacked Bar Charts

D

Darshan72

Hi

How do I hide Zero values in a stacked Bar Chart?

I want to display amounts in the bars but not when they have zero values.
Could you please help me.

Regards
Darshan
 
A

Andy Pope

Hi,

I assume you are referring to the data labels, in which case use a
custom number format to suppress zero.

General;General;

Double click the data labels and use the Number tab to add this number
format.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sideways stacked bar charts with line series on the same axis 0
Stacked Bar Chart 1
2007 move axis label & add zero line 1
Problem building horizontal bar chart paired bars, centered on zer 2
Stacked bar chart with totals - Excel 2003 2
Total number display in stacked charts 1
How to display zero value in blank fields of Cross Tab query 0
Stacked bar category labels over to the left side 2

Top