Autochart top 20 percent

's Computer Specifications

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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Percent Format: Allow user to type Percent, not decimal?	PeteCresswell	Microsoft Access	3	19th Dec 2007 09:48 PM
autochart-Add-in	FONE CHIN	Microsoft Excel Misc	3	12th Jul 2006 12:01 PM
Percent showing hundreds instead of actual percent number	=?Utf-8?B?SnVkeVQ=?=	Microsoft Access Reports	1	27th Apr 2006 03:27 PM
Formatting a number to look like a Percent without a percent sign	=?Utf-8?B?RGF2aWQgSWFjb3Bvbmk=?=	Microsoft Excel Misc	2	15th Sep 2005 06:35 PM
Percent Format without Percent Sign	=?Utf-8?B?anN0cmF0ZXI=?=	Microsoft Excel Programming	1	29th Apr 2004 07:28 AM