Excluding LIMITS with NEGATIVE values from CHART

[silvertabb]

Assume my Low-Limit specification is a negative NUMBER and all the Test data have positive values, how can I ask the excel spreadsheet to exclude series that have negative values automatically. Just to clarify my question a little more, see below:

Column A (Temperature)- 1,2,3,4,5.
Column B (Low Limit)- -2,-2,-2,-2,-2.

I wish to exclude the negative series from my plot automatically. Can you help?
I appreciate your help in advance.

Regards


P.S.
I have already set up a template using Dynamic Series. It would be great if I can incorporate the automatic exclusion of the negative series.

 

[tactps]

If you right-click on the y-axis of the chart, you can change the scale so that it starts from 0.

Either that, or have the data exclude zeros with an if formula:
=if(a2<0,0,a2)
Then adjust the chart options not to plot zeros.

Or if, by the example above, the lower limit is always negative, just don't include it in the source for the chart.

I hope I have understood your issue and explained myself correctly.