ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   graph, data lables value, dont show zero values (https://www.excelbanter.com/charts-charting-excel/176694-graph-data-lables-value-dont-show-zero-values.html)

Madeleine

graph, data lables value, dont show zero values
 


Jon Peltier

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
...





All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com