After choosing the type of Excel 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.