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
|
|||
|
|||
removing 0 value data labels
Hi All
How would I remove 0 Value data labels from a chart using vb script? |
#2
|
|||
|
|||
removing 0 value data labels
No need for VBA. You can make a custom number format for the labels.
Select the whole set of labels, press CTRL+1 to format, and on the number format, select Custom in the left hand list, and add a format like one of these: 0;0;;@ 0.0;0.0;;@ There are four items in a custom format, by default the formats for positive, negative, and zero values, and for text. Leave off the format for zeros, and the label will not appear. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Hi All How would I remove 0 Value data labels from a chart using vb script? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Re-sizing data labels in a chart | Mark | Powerpoint | 2 | May 27th, 2004 12:09 AM |
Data labels disappear in excel 2003 | Pavel B | Charts and Charting | 2 | December 12th, 2003 06:26 PM |
Data labels | Eric Hellman | Charts and Charting | 4 | November 15th, 2003 01:08 AM |
pie chart data labels | Marilyn | Charts and Charting | 2 | September 17th, 2003 09:11 PM |
maximun & minimum data labels | glen | Charts and Charting | 2 | September 16th, 2003 04:43 AM |