How to Put Two Sets of Data on One Graph in Excel

Next Video:
How to Add a Best Fit Line in Excel for a Mac....5

Putting two sets of data on one graph in Excel is something that you can do along the Y and X axes. Put two sets of data on one graph in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.

Part of the Video Series: Using Excel
Promoted By Zergnet


Video Transcript

Hi, I'm Ted. Today, I'm going to show you how to put two sets of data on one graph in Excel. This is the kind of thing that you, that is useful to know how to do when you have two different kinds of data that you want to plot on the y-axis, but you want the x-axis to be the same. So I have a sheet set up here with just some made up production data. I've got the week, the number of widgets produced per week, and the defects per week, and I want to make a plot where I have the widgets one axis and the defects on another axis. So there's different ways of making a chart, everybody has a different way of doing it, and depending on your operating system it may look a little different, but basically what we're gonna do is we're gonna select the whole sheet including the headers, because it's gonna know what to do with the headers. So we're going to go to the insert chart, and we're gonna select a scatter chart, and just simple points. And because we had the range all selected, it knew that we wanted the left-hand column as the x-axis and the other two columns as the y-axis, and it has them both plotted on the same axis and the headers ended up in our legends here. But what we wanted to do is we want the defects to be plotted on a different axis, because they're, it's a much smaller number, and you can't really see what's going on with them. So we're going to select them. Just single-click on them, and then we're gonna go to format, data series, and then we're going to go to axis, and we're gonna select secondary axis. Now as I said before, this, the exact menus you go to may appear a little differently depending on your computer and your operating system, but you want to look for something that has primary and secondary axis. Now we say okay, and now we see the widgets, which are from 0 to 3,500 are on the left axis, and the defects, which are from 0 to 250 are on the right axis. The points are all kind of jumbled together, so I'm gonna do one more thing so we can see them separately, and I'm gonna change the scale on the right-hand axis. So I double-click on the numbers on the axis, and I'm gonna change the maximum to 500, and we're gonna say okay, and you can see now you can see the data a little more clearly. So I hope this has been helpful. I'm Ted, and today I showed you how to put two sets of data on one graph in Excel. Thanks for watching.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!