Line graph with two lines that start at different x values

Hi Teylyn,
Thanks for your help. You guessed correctly; my data is pretty similar to the data that you've posted. The only differences that I can see are the following: 1.) The scale changes slightly in incrementation 2.) There is one value on the x-axis for the 2nd line (Russian) that doesn't have a value, since that value wasn't tested in that language. I'm attaching a copy of my data for your reference.

What I really need is a step-by-step walk through that will allow me to get the type of graph that you've created (if that's possible given my data), since your hypothetical graph reflects the format that I'd like to see.

Laura

Sorry for my ambiguity regarding the missing data point; what I meant to say is that there is one value on the x-axis that doesn't have a point on the 2nd (Russian) line.

Let me know if you have any questions.

Laura

Hi Teylyn,
Thanks for sending me the example graph (which displays as I would like it to on my version of Excel) and explaining to me how to select the data to create the type of graph that I want. However, I tried to replicate what you had done myself, but on my version of the graph (which I am attaching), the English line starts at -44 instead of at 0. I double-checked the values for the data ranges for both lines to ensure that they run from rows B2-B17 and C2:C17, and that the x-axis values in both cases also run from A2:A17. Do you have any idea what might be causing Excel to start the English line at -44, despite that the values in the spreadsheet for the English dataset don't start until 0? (Perhaps I should try selecting the Russian data first, although I don't see why this would make a difference.)

Here is a step-by-step description of what I did to create my version of the graph:
1.) Select English dataset (B2:B17).
2.) Select line graph from Chart ribbon.
3.) Go to Chart>Source Data... and select data for x-axis (A2:A17)
4.) Go to Chart>Add Data... and select Russian dataset.
5.) Select data for x-axis (A2:A17).

The menu layout in Excel 2008 for Mac is a bit different from the one in 2007 for Windows, so I am still trying to find the interpolate function (I'll keep working on that...it's got to be here somewhere). Also, I should mention that Excel v. 2008 for Mac is buggy, so if we can't come up with a solution for why Excel is starting the English line at -44 instead of at 0, it may very well be due to a glitch in the program itself.

Let me know if you have any further questions.

Laura

Hi Teylyn,
After some messing around within the Source Data dialog box, I was able to figure out how to solve the problem and make my version of the graph look like yours. At first, I tried selecting both datasets off the bat when creating the graph, as you suggested, but Excel divided it up oddly, so I had to respecify the values in the Source Data dialog. This time, I selected the Russian dataset first, and then added the English dataset. It seems that this may have made the difference, as I guessed.

Although I wasn't able to locate the menu option for interpolate, I found out that I can use the formula =na() in the empty cell, and it will perform the same function within the graph.

Thanks for all of your help!

Laura

Hi Teylyn,
I checked the Source Data dialog, but there is no such option in v. 2008. As I said, I'm sure it's here somewhere; it's just a matter of finding it. But for my purposes, the function worked.

I tried to mark the thread as solved yesterday, but I didn't see how to do it right away. I just looked under the How to...? thread and found the explanation of how to do it, so I did it.

Thanks for your help!

Laura