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.

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