When manually assigning values to the X and Y axis of an Excel chart using a non-contiguous range of data, what should be done first? Click a blank cell that is not adjacent to any cells containing data. Click the Select Data button in the Design tab of the Ribbon. Select the desired chart type from the Insert tab of the Ribbon. O Add a blank worksheet to the workbook. o Insert two blank rows above the dataset that is being used to create the chart