| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hiding Zeros in Stacked Bar Charts
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 |
|
#2
|
|||
|
|||
|
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 Darshan72 wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a stacked bar chart using time? | Charts and Charting in Excel | |||
| How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
| total value of stacked charts | Charts and Charting in Excel | |||
| initial size of new charts | Charts and Charting in Excel | |||
| Stacked Bar Charts | Excel Worksheet Functions | |||
Linear Mode
