LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Can I only show records on Graph that have more than 1 entry?


Right now one of the macros I right takes data from a table and
automatically turns it into the graph. The data table is generated to
have the top ten entries. The problem is, if a few entries are tied
with the same number of occurences they are all shown. This wouldn't
be a major problem. But if the top 10 includes records with 1 entry,
there are many records with 1 entry and they will all be shown cramped
up on the graph.

I'd like to know if it is possible to exclude all the entries in the
graph that only have 1 entry. The problem is, when I run the macro at
times, even with Top 10 being set, there could be many entries that are
tied with 1 record and all get cramped in the graph. Is it possible to
exclude records in the graph that only appear once?

Thanks,

~J

Ok what I wrote, does that make any sense? Its confusing to me to
read, but I hope you can understand


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=565107

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to show the figure of the filtered records ? Kaman[_2_] Excel Discussion (Misc queries) 1 May 16th 08 02:34 PM
How do I show break in bar graph to show large and small numbers GK Charts and Charting in Excel 1 December 19th 05 08:23 PM
How do I show break in bar graph to show large and small numbers GK Charts and Charting in Excel 0 December 19th 05 06:35 PM
How to Show Records with No Data.......... Srinivas Gudala Excel Discussion (Misc queries) 1 October 7th 05 08:13 PM
Some exported records do not show on spreadsheet vulcan88 Excel Worksheet Functions 0 March 30th 05 01:11 AM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"