Forum Discussion
billnowlin
Feb 25, 2024Copper Contributor
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 ...
peiyezhu
Feb 25, 2024Bronze Contributor
still leaves room for the 100,000 possible entries
Do you want to dynamic set data souece (from 6000 to 100000 rows) for a chart
like this situation?
https://club.excelhome.net/forum.php?mod=viewthread&tid=1682274&page=1&mobile&_dsign=1c4cf1d9
Do you want to dynamic set data souece (from 6000 to 100000 rows) for a chart
like this situation?
https://club.excelhome.net/forum.php?mod=viewthread&tid=1682274&page=1&mobile&_dsign=1c4cf1d9
billnowlin
Feb 25, 2024Copper Contributor
A dynamic set data source does sound like it would work. I've tried this once but it didn't work. But maybe there's another way to do it.
Not sure if the situation you linked covers my issue exactly. I can't really tell what that situation is trying to accomplish. Although it does seem like it's similar.
In terms of the range, I would want it to work between any number between 1 and 100,000.
Not sure if the situation you linked covers my issue exactly. I can't really tell what that situation is trying to accomplish. Although it does seem like it's similar.
In terms of the range, I would want it to work between any number between 1 and 100,000.
- Riny_van_EekelenFeb 25, 2024Platinum Contributor
billnowlin I you are on a modern Excel version, perhaps the attached (small scale) example does what you need.
- billnowlinFeb 26, 2024Copper Contributor
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.
- Riny_van_EekelenFeb 26, 2024Platinum Contributor
billnowlin Can you share your file? Upload it to Onedrive or similar. Much easier than looking at some screenshots.