• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Chart with data series more than 20,000 rows

G

GN0001

Member
Hello to all,

I have built a dynamic chart on 1000 rows, and it has been successful. Now I am asked to build a dynamic chart on a data series more than 20,000 rows. I use countIfs to pull the data from the database, but when I want to verify the value pulled by countIfs by using Excel Filter, Excel filter only shows the first 10,000 unique values, the filter doesn't show all 20,000 unique values. Therefore, I can Not make sure that values are correct.


1- Can we make dynamic chart on data series as much as or more than 20,000 rows? Is the dynamic chart right tool for this purpose?


2-What is the solution?


Regards,

GGGGG
 
Hi ,


Can you not have a helper column which just has the numbers 1 , 2 , 3 and so for all the 20000+ rows that you have ; once you have a filter , use a second filter on this helper column and use this helper column value >10000 to eliminate the first 10000 rows.


Narayan
 
Hello dan_1

All these are very useful, I was not thinking about pivot tables. My boss decided to move into Microsoft Access to do this project. Now I have to go a Access forum to find codes. She is insisting to take care of this project in Access with VBA codes or Macro, I have no idea what the difference is between VBA and Macros even.

Thank you,

GGGGG
 
----

I have no idea what the difference is between VBA and Macros even.

----


I don't have a good answer for this. Anyone? This can be done with access. I don't know if it's the most effective solution, though.
 
You must log in or register to reply here.
Back
Top