After choosing the type of chart click the next button. Now in the box of dialogue Source Data select the range with the data for the Excel chart . You can choose to display by rows or columns.