Hi there. I have an excel spreadsheet that is built around analyzing a large series of data entries. The primary data entry table has 100,000 rows to enter data (yes, I am potentially analyzing that much data). I'm trying to make charts that show the data. However, I have had the must frustrating time having the charts "zooming in" or changing the scope of the data shown. Specifically, the sheet needs to be able to analyze 100,000 rows of data, but will most of the time have far less data (2,000-6,000). The charts currently plot data for the cells that have entries, but the scope or zoom of the chart is for the full 100,000 cells, so the plotted data takes up a VERY small amount of the chart.
I have tried about every single possible way of getting around this based on other forums, tutorials, and even turning to ChatGPT and Copilot to help me, with no working solution. I've tried having formulas instead of blank cells that purposefully throw an error (NA()) in case a cell is blank, in hopes that I can use the "Hidden and Empty Cells" function of treating errors as blank cells. However, this only prevents the data from being plotted and the chart's scope does not change and still leaves room for the 100,000 possible entries.
This has been infinitely aggravating and am turning to the forums before losing all hope.
I look forward to hearing back. Thanks in advance.
Example of issue:
Hi there. Thanks for your help. I downloaded your example and that is exactly what I'm looking to do. I replicated this in mine and am stuck on how I should select the spill data in the chart. I select the range that the filter is spilling and that doesn't seem to update when the spill range does.
