Method 1: Edit Source Data 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’ ...

Use Excel's chart wizard to make a combo chart that combines two chart types, each with its own data set. Select the two sets of data you want to use to create the graph. Choose the "Insert" tab ...

You can create this graph with just a couple of clicks and then rely on behind-the-scenes macros to make it all add up and generate the graph. Graphing two sets of numbers in Excel lets you show ...