Hi Ashish,
Usually, it will take long time to load 100,000 rows and while exporting to excel. My suggestion would be create one or two listboxes with any of the key fields or most used fields. Limit the data by enabling calculating condition in chart properties. Something like count(customer)<20000. You can also display warning message like "Lines should not exceed more than 20000, Select one or more customers or Department from listboxes. You can also enable show frequency in listbox property. So that user can understand the line count by just seeing the listbox.
So the chart will not populate unless something has been selected. I don't think, you can load 100,000 like you said. You have to wait long time to export the chart even its populated. Surely, the user will irritate and ask you to optimise the chart. So, either user have to select only they want in list box (so the chart will show filtered data)or if they want all data then need to take all downloads part by part by selecting one by one customer in listbox.
Hope this helps.
