Can I only show records on Graph that have more than 1 entry?

N

nbaj2k

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
 

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

Outlook 2021 export question 0
Making a macro only work on certain files 2
Eliminate blank row at top of Text Box entries 3
add a chart in a Add-In 1
Using Styles In An Outline 0
How can I fix the graph in one page when new texts need to be inserted? 5
Real-Time Co-Authoring stops working 0
Finding the right style field in VBA 0

Top