Dynamic range to show only positive values

[SimonHughes]

Hello, I have a range of values from high to low in column A1:A50. These values will change dependent on data entry but some values will always be positive and some will always be negative but the number of positive/negative values will change. I want to show the positive values only in a line graph. Can anyone assist, much appreciated.

I am using Excel 2016

 

[steve the fish]

Create a named range such as:

=OFFSET(Sheet1!$A$1,0,0,COUNTIFS(Sheet1!$A:$A,">0"),1)

Create blank line chart then select data. Press the 'add' button. Then in 'series values' put your named range name including the sheet eg =Sheet1!MyChartRange

That will work if you have sorted list of numbers as you state.

 

[SimonHughes]

Create a named range such as:

=OFFSET(Sheet1!$A$1,0,0,COUNTIFS(Sheet1!$A:$A,">0"),1)

Create blank line chart then select data. Press the 'add' button. Then in 'series values' put your named range name including the sheet eg =Sheet1!MyChartRange

That will work if you have sorted list of numbers as you state.

Hi Steve, perfect! Many thanks and much appreciated