I want to chart the top 10 values of something in a column that contains a formula and which are unsorted. Moreover, some rows have been hidden in the spreadsheet, so manually sorting would make a mess.
Would it technically be possible to enter formulas where in the series values have to be entered (Select Data/Select Data Source/Edit Series/Series values)?
I thought of a combination of entering individual values, such as {2, 5, 7, 3} and a formula like =AGGREGATE(14,5,$N$3:$N$115, 1) in stead of the individual values. With such a formula I can filter the largest value, taking into account the hidden rows -and subsequently similarly the following numbers.
Would it technically be possible to enter formulas where in the series values have to be entered (Select Data/Select Data Source/Edit Series/Series values)?
I thought of a combination of entering individual values, such as {2, 5, 7, 3} and a formula like =AGGREGATE(14,5,$N$3:$N$115, 1) in stead of the individual values. With such a formula I can filter the largest value, taking into account the hidden rows -and subsequently similarly the following numbers.