View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default graph, data lables value, dont show zero values

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Madeleine" wrote in message
...