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.
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.
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. [1] X Research source
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.
If you see an error when trying to select a set of data, delete everything in the field and select that range again.
This method will combine the second set of data with the original data on the existing axes.
This method will combine the second set of data with the original data on the existing axes.
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.
Once you select some data, the series will appear under “Legend Entries (Series)” on the left side of the Select Data Source window.
