Creating Dashboards

Options

I'm trying to create dashboards and I keep getting "Selected data cannot be charted. Please select new range." I've tried a few different things and searched for a solution but nothing seems to work. It doesn't let me select a new data source, when I go to the sheet I want data from, it's greyed out and I can't select anything, as per below.


Answers