Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to show the figure of the filtered records ? | Excel Discussion (Misc queries) | |||
How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
How to Show Records with No Data.......... | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions |