Select Data For Chart In Excel 2016 For. Again with Excel 2016 youll need to hold down the control key. Click in the Chart data range box and then select the data in your worksheet.
Select All Charts Waterfall OK STEP 4. You can choose which so you can choose the specific columns rows or cells to include. Click Developer Insert Check Box From Control.
The Select Data Source dialog box appears.
Now click hold and drag your cursor to select the data that you want to be displayed in. Highlight all the data and go to Insert Recommended Charts STEP 3. The Select Data Source dialog window will open. On the Insert tab select the chart type you want.