Download ArticleDownload ArticleX
This article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 36,052 times.
Learn more...
Need to visualize more than one set of data on a single Excel graph or chart? This How.com.vn article will show you the easiest ways to add new data to an existing bar or line graph, plus how to plot a second data set to compare two sets of similar linear data on a single graph.
Steps
Open the sheet that contains your existing data. Use this method if you want to compare two sets of similar data on the same graph. For example, comparing sales for red t-shirts versus blue t-shirts in the same year.[1]- This method will create a second X and Y axis for the data you want to compare.
- If you want to combine a second data set with your existing data set rather than compare, see Adding More Data to a Graph on the Same Sheet or Adding More Data to Graph on a Different Sheet.
Add your new data in a separate column and/or row. If you haven't already done so, add the second set of data you want to compare to the first set somewhere on the same sheet as your existing data. The cells do not have to be adjacent.Advertisement
Right-click your chart and choose Select Data. This opens the Select Data Source dialog window.[2]- You can also click the graph once, select the Chart Design tab at the top, and then click Select Data on the toolbar at the top of Word.
Click the Add button on the Select data Source window. You'll see it under the "Legend Entries (Series)" header.
Type a name for this data range in the "Series name" field. This is how your data will appear on the graph and legend.- You can also click a cell that contains the name you want to use for this range to make that cell's value the name of the series.[3]
Click the "Series X values" field. This activates the field.
Use the mouse to select data for your second X axis. Once you lift your finger from the mouse, the range will appear in the "Series X values" field.- For example, if a set of dates runs along the X axis of your original data, select the second set of dates for this X axis.
Click the "Series Y values" field. This activates the Y axis field.
Select the data you want to use for your second Y axis. Use the mouse to highlight the new data you want to add to this second Y axis.- If you see an error when trying to select a set of data, delete everything in the field and select that range again.
Click OK. Now you'll see two different sets of data under "Legend Entries (Series)".
Click OK to display the comparison data. Your graph now displays a comparison of two sets of data on the same chart.
Advertisement
Open the sheet that contains your graph and data. Use this method if your graph and its existing data are on the same worksheet.[4]- This method will combine the second set of data with the original data on the existing axes.
Click anywhere on the graph. When you click the graph, you'll see lines and sizing handles surrounding the data that's already included. The second series of data you've added is not yet highlighted.
Drag the handles to select the new data. For example, if you added a new column of data to the right of the existing data, drag the rightmost handle to the right to include that column in the data selection range. The chart will update right away to reflect all of the data selected.[5]
Advertisement
Open the sheet that contains your existing data. Use this method if your graph and data are on separate sheets.[6]- This method will combine the second set of data with the original data on the existing axes.
Enter the new data next to your current data. Type the new data for your graph into the cells directly next to or below your current data.[7]
Right-click your graph and choose Select Data. This opens the Select Data Source dialog window.[8]- You can also click the graph once, select the Chart Design tab at the top, and then click Select Data on the toolbar at the top of Word.
Select all of the data you want to add. Leaving the Select Data Source window open, use the mouse to highlight all of the data you want to include in your chart, including the existing data.[9]- Once you select some data, the series will appear under "Legend Entries (Series)" on the left side of the Select Data Source window.
Click OK on the Select Data Source window. This closes the dialog window and adds the second data set to your chart.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
SubmitAdvertisement
Video
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
References
- ↑ https://edu.gcfglobal.org/en/excel2016/creating-and-opening-workbooks/1/
- ↑ https://support.microsoft.com/en-au/office/change-the-data-series-in-a-chart-30b55a30-1c2e-42d5-8ed1-3cc3ffb68036
- ↑ https://www.youtube.com/watch?v=u7V1LPVlHck
- ↑ https://edu.gcfglobal.org/en/excel2016/creating-and-opening-workbooks/1/
- ↑ https://support.microsoft.com/en-gb/office/move-or-resize-a-chart-f9d6087b-1d7b-4a72-8d81-1d0788ea783f
- ↑ https://edu.gcfglobal.org/en/excel2016/creating-and-opening-workbooks/1/
- ↑ https://support.microsoft.com/en-us/office/add-a-data-series-to-your-chart-25340cfb-3fa3-428c-82cf-79983125df12
- ↑ https://support.microsoft.com/en-us/office/add-a-data-series-to-your-chart-25340cfb-3fa3-428c-82cf-79983125df12
- ↑ https://support.microsoft.com/en-us/office/add-a-data-series-to-your-chart-25340cfb-3fa3-428c-82cf-79983125df12
About This Article
How.com.vn Technology Writer
This article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 36,052 times.
How helpful is this?
Co-authors: 4
Updated: April 9, 2024
Views: 36,052
Categories: Microsoft Excel
Article SummaryX
1.Right-click the graph and select Select Data.
2.Click Add.
3.Type a name for the range.
4.Click the "Series X values" field and then select data for the X axis.
5.Click the "Series Y values" field and select data for the Y axis.
6.Click OK and then OK again.
Did this summary help you?
Thanks to all authors for creating a page that has been read 36,052 times.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
Advertisement
