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.

Step half dozen

Printing "Ctrl-South" to save this worksheet.

References

Tips

• To modify the chart type, right-click the chart'due south plot area to open the list then click "Change Chart Type" to open up the dialog box. Select the preferred chart blazon in the sidebar of the Recommended Charts tab sheet or the All Charts tab sheet to preview. Click "OK" to close the dialog box and update your nautical chart. Press "Ctrl-S" to save this updated worksheet.
• Updating the worksheet data volition update the chart data.
• To move the chart on your worksheet, click inside the chart area outside of the plot area and so drag the chart to the preferred position. For instance, move the chart to ensure it is not blocking the worksheet data.
• To resize the nautical chart, click inside the nautical chart to brandish the frame'southward sizing handles, and so click and drag a handle to change the dimensions.

Warnings

• Information in this article applies to Microsoft Excel 2013, Home & Business. It may vary slightly or significantly with other versions or products.

How To Plot Two Sets Of Data On One Graph Excel,

Source: https://itstillworks.com/put-two-sets-data-one-graph-excel-12309183.html

Posted by: woodmomenten1943.blogspot.com

Share this post