LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
ABS ABS is offline
external usenet poster
 
Posts: 6
Default Hiding 0 value data labels in chart

On Apr 16, 2:50*pm, Jon Peltier wrote:
No need for all of this code...

Use a custom number format like this:

0.0;;;

This format says to use "0.0 for positive numbers, and omit negative
numbers, zero values, and text when displaying the labels.

- Jon

**Snip**
No need? No need?
You mean there is a simple, direct, and effective way to do something
for which I've devised an over-complicated but clever work-around?
Well I never...really...where's the fun in that?
ABS
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pie Chart Data Labels Jake Charts and Charting in Excel 2 July 10th 07 09:42 AM
Pie Chart Data Labels David Benson Charts and Charting in Excel 0 May 24th 06 10:59 PM
Data labels in Chart Laura New Users to Excel 1 May 25th 05 06:33 PM
Pie Chart Data Labels gb_S49 Charts and Charting in Excel 4 January 26th 05 02:37 PM
Data Labels in a Chart Raul Excel Programming 2 December 27th 04 06:17 PM


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"