graph, data lables value, dont show zero values

J

Jon Peltier

Re: graph, data lables value, dont show zero values


I suppose there's a question somewhere.

It sounds like you need to apply a custom number format. Whatever the format
is now (for example, General or 0.00), use it as the first piece of the
number format, then leave the other out. So the format will look something
like

General;;;
0.00;;;

More on number formats:

http://peltiertech.com/Excel/NumberFormats.html

- Jon
 
Top