We know that a chart uses source data. In this tutorial I show you how to use an OFFSET function to store multiple source ranges in a defined name. Since our Defined name is controlled by a Drop List, Changing our selection from the Drop List automatically changes our Chart. It's an amazing technique for creating unlimited charts for a Dashboard
You can download the start file and follow along by clicking on the link:
https://www.amazon.ca/clouddrive/shar...