Autochart top 20 percent

R

Rookie_User

I have six columns of information. Column C contains numbers ranging from
zero to 90. I want to graph only from 70 and above OR I want to graph only
the top 20%. Is it possible?
 
B

BobT

Sort the data by C then create your graph on just the range you want (e.g.
first 20 rows). When/if new data arrives, simply resort your data and your
chart will display the values in the rows you originally selected (not the
original data).
 
Top