When creating a chart for a dashboard how can I select an entire sheet?

Alison Antisz

1) When creating a chart for a dashboard how can I select an entire sheet? Currently when selecting the sheet (in Add Chart Data Screen) the ok button is grayed out. Sometimes it automatically selects all items in the sheet, but often I need to drag the entire sheet in. Is there a way to get the entire sheet selected with a single click?

SoS | Dan Palenchar

If you use a report it will select everything by default. If you continually add rows to the Sheet this is probably a better practice as the data will remain current without needing to re select anything.