I am pretty close, but I have something messed up in my name range, so my chart is wrong. My Data is listed in a worksheet, while my chart will be part of a mini dashboard on another worksheet. The top chart (chart!) is my attempt to create a dynamic source for the chart. The bottom chart is a simple example of what I am trying to do.
my name range:
Then I set my chart data source to:
But, I am still getting the formulas listed in my chart.
I am not certain if I need to create an offset for each series (test score, average), then assign each series as the chart source data. In my reading, I have seen it both ways. The examples are always a bit different, so hard to know exactly what fits.
**After more reading, I think I might need to set up a name range for the data labels and each series (score and average). I can see my formula above is looking for both the column and the rows, but I found many more examples on how to do it separately. Ideally, I would like to learn how to combine the function, so I can be more versatile in my approach. I totally get what I am trying to do, but just missing something to make it click.