You can insert a Dynamic Chart in Excel using this tutorial. Learn how to convert data into table to add a dynamic chart in a spreadsheet.

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.

If you want to add a header or footer to all sheets, select every sheet by right-clicking one of the sheet tabs at the bottom of the Excel screen and clicking "Select All Sheets" in the pop-up menu.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

In this guide, I'll walk you through the different ways to format your chart, with Excel's main chart-formatting actions written in bold so you can find them more easily.