Dear all,
I am currently facing the following problem (see attached file):

My excel file is listing some houses and some numbers.
I have defined dynamic named areas for the numbers.
In the cells C7 and D7 I implemented two dropdown menues which can be combined individually and which show all the names of the named areas.
Next to those cells there is a chart which is supposed to take the named areas as data input.

I know that I am able to use a named area as data-input for a chart by using the formula =Table1!Name (generalised).
My problem is that I don't want to type in every named area by hand. My aim is to use the information in cells C7 and D7 to automatically generate the chart. This means I have to rewrite the formula =Table1!Name in a way that makes the formula recognize that cells C7 and D7 are listing the named areas' names.
My attempt was the following: =Auswertung!"$C$7" but this does not work.
Could you please help me?
Thank you so much!
Best regards
Tim