Forum Discussion
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 ...
billnowlin I you are on a modern Excel version, perhaps the attached (small scale) example does what you need.
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.
billnowlin Can you share your file? Upload it to Onedrive or similar. Much easier than looking at some screenshots.
