Ok relatively simple looking question compared to some of the others here, but I feel like I'm missing something completely obvious. Fairly big excel noob atm.
I want to display on a line graph how efficient 2 different sort types are, and one is better than the other. I want swaps as the X axis and then comparisons as the Y axis. I'm trying to make it so there's 2 lines that stop at the same 3 x axis values, and have different Y values.
I can't figure out how to lay it out so that when I select the data that the graph shows properly. It gives me different "series" atm. Anyone have an idea where I'm going wrong?
Personally I always do graphs as Pivot Charts. Makes it much easier to rearrange (and I spend most of my time working with pivot tables so that's the way I think).
Ok relatively simple looking question compared to some of the others here, but I feel like I'm missing something completely obvious. Fairly big excel noob atm.
I want to display on a line graph how efficient 2 different sort types are, and one is better than the other. I want swaps as the X axis and then comparisons as the Y axis. I'm trying to make it so there's 2 lines that stop at the same 3 x axis values, and have different Y values.
I can't figure out how to lay it out so that when I select the data that the graph shows properly. It gives me different "series" atm. Anyone have an idea where I'm going wrong?