1. Open your Excel workbook and locate the graph you want to add your second set of data. 2. Right-click on the graph and select ‘Select Data.’ 3. A ‘Select Data Source’ window will appear on the ...

Excel provides 10 different chart types, such as bar, pie, column, area, etc. Select the Insert tab, then choose the Recommended Charts icon in the Charts group on the Ribbon bar.