How To Plot Two Sets Of Data On One Graph Excel

How to Put Two Sets of Data on I Graph in Excel

By Kathryn Hatashita-Lee

i Jupiterimages/Comstock/Getty Images

Microsoft Excel offers many chart types to illustrate two data serial in a visually interesting way. The "Insert" tab on the command ribbon includes a Charts group with ten 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 besides enables you to plot ii different chart types, such equally a cavalcade chart for the start information series and a line chart for the second series, on a combination chart to help make these values meaningful for your analysis.

Step ane

Click and drag on the worksheet information that you want to chart. Include the row and column labels.

Step 2

Click the "Insert" tab on the command ribbon, and then click the tiny arrow push button in the lower-right corner of the Charts group to open the Insert Nautical chart dialog box. The Recommended Charts tab volition brandish your selected data series in a sample chart in the principal pane. Other sample charts will display in the side bar. If you prefer to see more chart types, click the "All Charts" tab to view a list of chart types in the sidebar. Examples include "Column," "Line," "Bar," "Surface area" and "Philharmonic."

Pace 3

Click a chart type in the sidebar to preview your data serial converted to that nautical chart type. For example, click "Philharmonic" in the All Charts sidebar to testify 2 chart types in one plot area, such as a column and a line chart. In this philharmonic example, you select the chart type for each data series in the drib-down list in the "Choose the Chart Blazon and Axis for Your Information Series" section.

Step iv

Click "OK" to convert the 2 data serial to a chart on your worksheet.

Pace 5

Click inside the nautical chart surface area to bring up the Chart Tools ribbon and the Design and Format tabs to assistance you lot edit the chart. Three buttons will display to the right of the chart with screen tips: Nautical chart Elements, Chart Styles and Chart Filters. For case, click the light-green "+" button for Chart Elements, and so select "Data Tabular array" to insert the worksheet data in the lesser of the chart.