Open Excel's Format Legend pane by right-clicking the legend in a chart and selecting "Format Legend." Click the window's Fill and Line icon, shaped like a paint bucket, followed by "Fill." ...

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 ...

Open the Excel 2010 spreadsheet that holds the two charts you want to make into one. Click on the first chart to activate it, then click on any of the data series that make up the chart.