Autochart top 20 percent

  • Thread starter Thread starter Rookie_User
  • Start date Start date
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?
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Six columns randon no.'s no dupes 6
Automatically Update Excel Graphs 3
Modify working code to expand the output. 5
Hiding columns 6
Excel Subtracting multiple columns from another column 3
COMBINATORIAL SUM !! 8
Scatter Plot Question - adding straight lines 0
Multiscaling the same graph 1

Back
Top