Forum Discussion

billnowlin's avatar
billnowlin
Copper Contributor
Feb 25, 2024

Automatically change chart scope (zoom) for data that exists in series

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:

 

5 Replies

Resources