How to Make Charts and Tables for an Excel Report Creating ... select the type of chart you want to add to the report sheet. In the Chart Design menu, in the Data group, select Select Data.