I’ve been working on a series of spreadsheets with the same type of data (they’re outputs of benchmarking data for my videocard), and have been experimenting on how to streamline my workflow.
I’ve recently attempted to make named database ranges for each of my 10,000’s-of-rows data columns in lieu of manually selecting them for the data selection part of the chart wizard. Alas, it seems it’s not as intuitive as I first thought.
How can I make use of the named ranges I made to easily plug into a new chart? Is it even possible?