|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 3rd, 2005, 09:31 AM
|
|||
|
|||
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
February 3rd, 2005, 10:18 AM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| comparison charts - stacked graphs | ehpando | Charts and Charting | 1 | June 22nd, 2004 01:57 AM |
| Stacked Charts | LttlFriend | Charts and Charting | 1 | June 14th, 2004 10:42 PM |
| Stacked Area Charts | McBeastly | Charts and Charting | 2 | May 25th, 2004 05:43 PM |
| Stacked pie charts | Debra Dalgleish | Charts and Charting | 3 | November 15th, 2003 03:11 AM |
| Multiple Stacked Bar Charts, Data Organitation | Bull Splat | Charts and Charting | 1 | November 11th, 2003 05:13 PM |
Linear Mode
