How not to plot zero in graph ?

M

Mire

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(B1>0,B1/C1,NA())

I need to use a pie-graph.

Tnks in advance
M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros to convert Data into date format and then plot in graph 7
Handling hhmmss time format 6
plot excel chart against datetime 0
VBA Coding Help for Beginner 0
Enter NA() into All Blank Cells in Range 16
Plotting duration of activity on a graph 1
Dynamic Graphs - code needed? 1
Trendline Not Appearing In Chart Problem ? 0

Top