Dynamic Name range for charts

It's not at all clear (at least to me) what it is you're trying to achieve. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.
I see no chart nor defined range name nor understand what you mean by 'target'.

Remember that when you ask a question in a forum those of us who might be able to help know absolutely nothing about your system and work process or the terminology you use. Unless you have uploaded a workbook we know nothing about how it is laid out and little about what you want done with it or how the results should be presented.

Whilst these things are second nature to you since you live with the workbook all the working day we start with zero knowledge so you need to take us by the hand and explain in quite precise detail your aims and goals as well as stuff like how your data might look different in other situations.
Don't assume we are able to "figure it out". We're usually quite good but not prescient.

Put yourself in our position and think about whether what you've posted makes sense and is unambiguous to someone who's never seen it before.
You are asking us for help so help us to be able to help you by providing all the information we need, even if that information seems obvious or intuitive to you.

Did you attach the right sheet?

there are:

no charts
no formulae
no named ranges

in the sample file!!

I don't see the relation between the data on Sheet1 and the matrix on Sheet2.
Assuming that there is a relationship then it may be better to attempt producing a pivot table and pivot chart from the data.
In the attached copy of the file the matrix on Sheet2 is converted to a table and the resulting chart shows the names instead of series numbers.
Additionally the Target series can be charted as a line.
Let us know if you have any questions.

You're Welcome. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.