plotting a chart with positive only numbers

[omri]

Appreciate feedback on "iffing" a chart.
e.g. do not plot (or display) negative numbers.
Doable?

 

[Andrew Poulsom]

One way is to AutoFilter the list and custom filter for values greater than zero. The chart will then only plot the visible cells.

 

[Mark W.]

...if the Tools | Options... menu command's "Plot visible cells only" option (found on the Chart tab) is checked.

 

[omri]

Thanks but,
I am obviously doing something wrong. I have one row with data (#NUM!, negative, 0 or positive).
Autofiltered the row. Then, tried to custom by using "is greater than" and typed "0" in the box to the right.
Nothing happens. ?

 

[Mark W.]

AutoFilters are assigned to columns -- not rows.

 

[omri]

ok,
so how then can I plot the chart with "only" positive numbers?

 

[tusharm]

Option 1: Double-click the y-axis. In the scale tab, set the min. value to zero.

Option 2: In the row below the one with the data, add the formula =IF({cell-above}>=0,{cell-above},NA()). Plot this second row.

Option 3: Do the same as (2) but use a named formula.

 

[omri]

Thanks, option 1 was the answer.
Whats do you mean by "named formula"?

 

[tusharm]

For an example of a named formula, check the 'Dynamic Charts' page of my web site.