ExcelBanter - Autochart top 20 percent

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Autochart top 20 percent (https://www.excelbanter.com/excel-programming/419925-autochart-top-20-percent.html)

Rookie_User

Autochart top 20 percent

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?

Bobt

Autochart top 20 percent

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).

"Rookie_User" wrote:

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?

All times are GMT +1. The time now is 12:28 PM.