How To Make A Line Graph With 2 Sets Of Data
How to Put Two Sets of Data on One 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 manner. The "Insert" tab on the command ribbon includes a Charts grouping with 10 chart types, including "Pie," "Bar" and "Surface." For example, if your data series includes positive and negative values, the recommended preview samples volition include column and line charts. Excel also enables you to plot two different chart types, such equally a column nautical chart for the first information series and a line chart for the second serial, on a combination chart to help make these values meaningful for your assay.
Step ane
Click and drag on the worksheet information that y'all want to nautical chart. Include the row and column labels.
Footstep ii
Click the "Insert" tab on the command ribbon, and so click the tiny arrow button in the lower-right corner of the Charts group to open the Insert Nautical chart dialog box. The Recommended Charts tab will brandish your selected data series in a sample chart in the master pane. Other sample charts will display in the side bar. If you adopt to see more nautical chart types, click the "All Charts" tab to view a list of chart types in the sidebar. Examples include "Cavalcade," "Line," "Bar," "Surface area" and "Combo."
Stride 3
Click a chart blazon in the sidebar to preview your data series converted to that chart type. For case, click "Combo" in the All Charts sidebar to show 2 nautical chart types in one plot area, such equally a column and a line chart. In this philharmonic instance, you select the nautical chart type for each data series in the drop-downward list in the "Choose the Chart Type and Centrality for Your Data Series" section.
Stride 4
Click "OK" to convert the two data series to a chart on your worksheet.
Pace 5
Click inside the chart area to bring up the Chart Tools ribbon and the Pattern and Format tabs to help you lot edit the chart. Three buttons will display to the right of the nautical chart with screen tips: Chart Elements, Chart Styles and Nautical chart Filters. For case, click the greenish "+" button for Chart Elements, and then select "Information Table" to insert the worksheet data in the bottom of the chart.
Stride 6
Press "Ctrl-Southward" to save this worksheet.
References
Tips
- To change the nautical chart type, right-click the nautical chart's plot area to open the listing and then click "Change Chart Blazon" to open the dialog box. Select the preferred chart type in the sidebar of the Recommended Charts tab sheet or the All Charts tab canvass to preview. Click "OK" to close the dialog box and update your chart. Press "Ctrl-S" to save this updated worksheet.
- Updating the worksheet data will update the nautical chart information.
- To motility the nautical chart on your worksheet, click inside the chart area outside of the plot surface area and then drag the nautical chart to the preferred position. For example, move the chart to ensure it is non blocking the worksheet data.
- To resize the chart, click inside the nautical chart to display the frame'south sizing handles, and and so click and drag a handle to change the dimensions.
Warnings
- Information in this article applies to Microsoft Excel 2013, Habitation & Business organization. It may vary slightly or significantly with other versions or products.
How To Make A Line Graph With 2 Sets Of Data,
Source: https://itstillworks.com/put-two-sets-data-one-graph-excel-12309183.html
Posted by: burkemasimed.blogspot.com
0 Response to "How To Make A Line Graph With 2 Sets Of Data"
Post a Comment