Microsoft Excel gives you a number of tools to build, update and manipulate graphs and charts. If you want to take the data from one chart and place it on another chart, Excel gives you two ways ...

How to Add an Overlay to Excel. Microsoft Excel 2010 can create a chart to illustrate numeric data from a worksheet. Excel's "Chart Tools" contain "Labels" that customize the chart area.

Next, create the column and line sparkline charts you want to overlay, as suggested in the screenshot below. Continue by highlighting the first sparkline line chart (cell H7 in this example) and ...