Microsoft Excel offers many chart types to illustrate two data series in a visually interesting way. The “Insert” tab on the command ribbon includes a Charts group with 10 chart types, including “Pie,” “Bar” and “Surface.” For example, if your data series includes positive and negative values, the recommended preview samples will include column and line charts. Excel also enables you to plot two different chart types, such as a column chart for the first data series and a line chart for the second series, on a combination chart to help make these values meaningful for your analysis. Tips Warnings

How to Put Two Sets of Data on One Graph in Excel - 37