Combining Two Chart Types

Sometimes a chart with two or more data series is easiest to understand if one or more of those series is plotted in a chart type that contrasts with the rest of the chart—for example, if one series is plotted in columns and another is plotted as a line. Excel makes it easy to create an “overlay” chart of this kind. First create the chart by plotting all the series using the same chart type. Then right-click any point or marker in the series you want to change. For example, if you want to change a series plotted as columns so that it’s plotted as a line instead, right-click one of the columns in that series. On the shortcut menu that appears, choose Change Series Chart Type. This takes you to the gallery of chart types. Select the one you want, and click OK.