ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How not to plot zero in graph ? (https://www.excelbanter.com/excel-programming/277879-how-not-plot-zero-graph.html)

Mire

How not to plot zero in graph ?
 
I am trying to figure out a way to eliminate plotting the LINE
chart when the value is negative or no value.
I use NA() but the graph plot zero !
=IF(B10,B1/C1,NA())

I need to use a pie-graph.

Tnks in advance
M





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

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