How to Put Two Sets of Data on One Graph in Excel
One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as a complicated collection of data. For instance, you can create a chart that displays two unique sets of data. Use Excel's chart wizard to make a combo chart that combines two chart types, each with its own data set.
-
1.
Select the two sets of data you want to use to create the graph.
-
2.
Choose the "Insert" tab, and then select "Recommended Charts" in the Charts group.
-
3.
Select "All Charts," choose "Combo" as the chart type, and then select "Clustered Column - Line," which is the default subtype.
-
4.
Choose the type of chart you want to use for each data set in the table at the bottom of the Insert Chart dialog. Select the "Secondary Axis" box for the data you want to move to the secondary axis.
-
5.
Click "OK" to create the combo chart. Press "Ctrl-S" or click the "Save" button to save the changes to your workbook.
References
Warnings
- Information in this article applies to Excel 2013. It may vary slightly or significantly with other versions or products.
Writer Bio
Tricia Goss' credits include Fitness Plus, Good News Tucson and Layover Magazine. She is certified in Microsoft application and served as the newsletter editor for OfficeUsers.org. She has also contributed to The Dollar Stretcher, Life Tips and Childcare Magazine.