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