Combining Ctrl + Shift + Arrow keys lets you extend your selection in any direction until Excel hits a blank cell. Start from the top-left corner of your data, try Ctrl + Shift + Right Arrow, then ...
Before doing this, have more than one worksheet tab open. Select the chart, then go to the Chart Design tab. In the Location group, click the Move Chart button. In the Move Chart dialog box. Select ...