Below is a video that may help you as well.
How-to make a Dynamic Excel chart that doesn’t show blank values so you don’t have to use filters.
It uses a combination of Index and Match functions along with an Offset function.
Here are other links to posts that involve Index/Match and Offset Function techniques to build Excel Charts:
Video Demonstration: http://youtu.be/JA2r_9RjLCs
Steve=True
Quickly learn the tricks to make an Excel Clustered Stacked and Multiple Unstacked Chart.
Selecting chart elements changed in Excel 2016 2019 and Office 365. Learn how to easily change chart element selections with this quick tip. The technique you used in previous versions of E
Learn how to fix a problem with my Thermometer template that was created in the original version of the Excel chart when the Sales is greater than the goal.