Why can't I add chart data?

I want to make a chart, however, I can't seem to add any valid data into dashboard. The referenced data is greyed out (see picture) and if I press OK, then a red text comes up saying; "Selected data cannot be charted. Please select a new range".

How do I solve this issue?

Screenshot (2).png


Answers