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